Can a table have two primary keys?

Question Posted / pk

44 Answers
84424 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 / anand

Yes table can have two or more primary key,when we want to
create more then one primary we use unique constranit with
not null or we can create with triggre.

Is This Answer Correct ?

1 Yes

6 No

Can a table have two primary keys?..

Answer / sandeep yadav

Yes table can have two or more primary key.

Is This Answer Correct ?

1 Yes

9 No

Can a table have two primary keys?..

Answer / ashwin kumar

yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.

Is This Answer Correct ?

25 Yes

43 No

Can a table have two primary keys?..

Answer / jamalvalli

Yes we can use. for Example

create table emp(empno number(5), ename varchar2(20),
deptno number(5) add primary key Pk_constraint( empno,
deptno))

Is This Answer Correct ?

18 Yes

38 No

Post New Answer