is it possible to assign two primary key in a table

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / pr

8 Answers
9883 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it possible to assign two primary key in a table ..

Answer / sushma s

A table can have only one primary key assigned.

Is This Answer Correct ?

19 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / sudipta santra

IF WE MAKE COMPOSITE PRIMIRAY KEY THEN ONLY MORE THAN ONE
COLUMNS WILL BE BIND UP.

Is This Answer Correct ?

11 Yes

1 No

is it possible to assign two primary key in a table ..

Answer / jd

At the end of the day a primary key is unique non null value
that the data is indexed upon.

Even if only one column can be explicitly defined as the PK.
It is possible to uniquely identify a row differently, by
creating a unique non null column that is indexed. It is
implicitly then a PK.

Is This Answer Correct ?

4 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / vignesh lakshmirajan

Answer is strictly NO...!!!

we may have morethan one unique column in a table but we should assign only one primary key...!!

Is This Answer Correct ?

3 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / guest

no it doesn't possible

Is This Answer Correct ?

3 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / rajan

any if one time primary key in a table

Is This Answer Correct ?

0 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / kunal

yes, it is called composite key

Is This Answer Correct ?

0 Yes

0 No

is it possible to assign two primary key in a table ..

Answer / rajan bajalia

yes

Is This Answer Correct ?

1 Yes

2 No

Post New Answer