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
- 4353 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
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is dml command?
Can I work with several databases simultaneously? : sql server management studio
How to search for a string in all stored procedure in sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain temporary table vs table variable by using cursor alternative?
What is mapping schema?
How to list all schemas in a database?
What is the difference between locking and multi-versioning?
System requirements for sql server 2005 express edition?
What is normalization? Explain its different types?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is a benefit of using an after insert trigger over using a before insert trigger?
