If any possiable to use 2 primary key in single table? How many primary key &am

If any possiable to use 2 primary key in single table?
How many primary key & foreign key used in each table(min &
max)?

Question Posted / sujatha_k

3 Answers
4348 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If any possiable to use 2 primary key in single table? How many primary key & foreign key used ..

Answer / manikanta.srinu

Table can have only one primary key.243 foreign key can
poosiable for a table

Is This Answer Correct ?

7 Yes

1 No

If any possiable to use 2 primary key in single table? How many primary key & foreign key used ..

Answer / rajkumar

A table can have only one foreign key and 253 foreign keys can have in a single table.

Is This Answer Correct ?

2 Yes

1 No

If any possiable to use 2 primary key in single table? How many primary key & foreign key used ..

Answer / amit kumar sharma

A table can have only one cluster index i.e. Primary key
and 249 non-cluster index i.e. foreign key.
Cluster Index have 3 leaf in b-tree and the last node
itself containing data.
While Non-cluster index have 4 leaf in b-tree and the 3rd
node containing the ref of data (4th node).

Is This Answer Correct ?

1 Yes

0 No

Post New Answer