If any possiable to use 2 primary key in single table?
How many primary key & foreign key used in each table(min &
max)?
- 3 Answers
- 3892 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain transaction server isolation?
What are scheduled tasks in sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is difference between drop truncate and delete?
Give me any three differences between Truncate and Delete.
What is the difference between system objects and user objects?
How to create user defined functions with parameters?
What is the difference between functions and stored procedures?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are the database objects? : SQL Server Architecture
What is the difference between Normalization and De-normalization?
why would you use sql agent? : Sql server database administration
Mention the differences between substr and charindex in sql server.
How do I connect to sql server database?
What are sql azure firewall rules?
