Answer / ramireddy

No, A table having only one primary key.
If you declare as Primary
key(<column_name>,<column_name>,<column_name>) for any
table. This type key is called as composite key.

Answer / hari

no. a table can have only one primary key.some times table
can use composite primary key

ex create table std
(stdid bigint(10) not null,
e mailid varchar(20) not null);
primary key(stdid,e mailid)

Answer / chandu

We can create only one Primary kay in a table but it can
have multiple columns, of them we only choose 1 column as
identifiable column called primary key and the other columns
are called candidate key(s).

Answer / abdul kuddus

Yes, A table can have maximum 16primary key columns in a table

Answer / venkatesh

No,why because in one table in one primary key.so can use two primary key in a table that type of key is composite primary key.

Answer / sruthi

yes table can contain one or more than one primary keys
but only one is considered as a primary key .

Answer / anup ghosh

hi gyes please removw who have writen wrong ans. One table
can have only one primary key other wise it is not a good
database design.also my knowledge says that only one tabl;e
can have only one promary key........

Answer / biju

Perfect answer Mr. Satish Reddy. Appreciated

Answer / subbu

Well the question is

Can a table have two primary keys?

Practically Yes.

But theoritically there will be only 1 primary key with
multiple foriegn keys which acts as a composite keys for the
original primary key. How ever in the create or alter
statements, we need to write primary key only once following
the column names either single or multiple.

By seeing the posts, I believe some of the guys has got
confused with the question & compared it with the SQL create
statements where in Primary Key is written only once & by
which concluding that a table cannot have multiple primary keys.

Answer / kumar navdeep shanker

Ya, it is possible..
try with this Query..
create table cust11
(
cno int not null,
balance int not null,
cname varchar(10),
CONSTRAINT cust primary key (
cno,balance)
)

If there is any Problem.. plz reply

How many columns should be in an index?

0 Answers  

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

when normalization is required

3 Answers   HCL,

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

What is Data Concarency and Consistency?

1 Answers  

Is primary key an index?

0 Answers  

What does count (*) mean in sql?

0 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

Is pl sql better than sql?

0 Answers  

What are the types of functions in sql?

0 Answers  

What is the purpose of a sql?

0 Answers