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

what is variable in package specification

3 Answers  

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

What is oracle pl sql developer?

0 Answers  

Can we use ddl statements in stored procedure sql server?

0 Answers  

What is sql select statement?

0 Answers  

What has stored procedures in sql?

0 Answers  

How to use distinct and count in sql query? Explain

0 Answers  

What is sqlservr exe?

0 Answers  

what are the join types in tsql? : Transact sql

0 Answers