Its possible to add more than one primary key for the table

Question Posted / siri

4 Answers
7002 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Its possible to add more than one primary key for the table ..

Answer / rajesh venati

No, it is not possible, only one primary key is possible for
a table.
It is possible to create a primary key on more than one
column in a table, up to 32 columns. It is called composite
primary key.

Is This Answer Correct ?

19 Yes

2 No

Its possible to add more than one primary key for the table ..

Answer / ravi singh

No, physically its not possible to add more then one primary key on a table, although logically you can create an unique key on a column and put it as not null .

Is This Answer Correct ?

8 Yes

1 No

Its possible to add more than one primary key for the table ..

Answer / mahesh katkam

NO its not possible to add more than one primary key in one table , but using trigger we can make another non_primary column acts as primary key column.

Is This Answer Correct ?

1 Yes

0 No

Its possible to add more than one primary key for the table ..

Answer / ramesh

No not possibble add more than one primay key on the table

Is This Answer Correct ?

0 Yes

0 No

Post New Answer