Can a table have two primary keys?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / pk

44 Answers
97016 Views
HCL, MetaCube, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can a table have two primary keys?..

Answer / dev

A Table can't have two primary key.

Is This Answer Correct ?

5 Yes

3 No

Can a table have two primary keys?..

Answer / suresh babu

No,The Table should have one primary key.But we can create
single primary key for combination of more columns,which is
called Composite Primary Key.

Is This Answer Correct ?

2 Yes

0 No

Can a table have two primary keys?..

Answer / damini

No.A table can have only one primary key .if it is having
more than one primary key then we say it as composite
primary key...A composite primarykey is a primary key of 2
or more columns together..A composite primary key is
different from primary key..

Is This Answer Correct ?

2 Yes

0 No

Can a table have two primary keys?..

Answer / yes

yes

Is This Answer Correct ?

4 Yes

3 No

Can a table have two primary keys?..

Answer / subbarayulu

No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.

Is This Answer Correct ?

2 Yes

1 No

Can a table have two primary keys?..

Answer / srilekha

no,it's not possible to set more than one primary key column
to a single table

Is This Answer Correct ?

2 Yes

1 No

Can a table have two primary keys?..

Answer / sattprakash mittal

Primary key is a field which is uniquely identified each record in a table. A table can only one primary key but there are more field can be used as primary key are known as candidate keys

Is This Answer Correct ?

2 Yes

1 No

Can a table have two primary keys?..

Answer / vikneswaran

no,table can have only one primary key.

Is This Answer Correct ?

1 Yes

0 No

Can a table have two primary keys?..

Answer / pardeeep

NO,A table have only one primary key.But we can use it on more then one column.
Exp..
create table emp(empno int,ename nvarchar(20),deptno int,constraint Pk_constraint primary key( empno,deptno))
This query for SQL server

Is This Answer Correct ?

1 Yes

0 No

Can a table have two primary keys?..

Answer / iamanocp

A table can have only 1 primary key

Is This Answer Correct ?

1 Yes

0 No

Post New Answer