Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4990 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
If we delete pack Spec what will be the status of pack Body ?
what is a traditional network library for sql servers? : Sql server database administration
Why are you getting errors when creating a new odbc dsn?
What does nvl stand for?
Why are views required in the sql server or in any other database?
What is a primary key?
Describe how to use linked server?
what is blocking? : Sql server database administration
What the different components in replication and what is their use?
Explain what is the difference between union and union all?
How to deploy the Report?
Explain transaction server auto commit?
What is dml command?
What methods do you follow to protect from sql injection attack?
List the data types available in mssql?
