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
- 5027 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
What is the native system stored procedure to execute a command against all databases?
Which are new data types introduced in sql server 2008?
What is a document index?
How to create an inline table-valued function?
Explain log shipping and mention its advantages.
Explain comment on transactions?
Does a sql server 2005 select statement require a from?
What are scalar functions in sql?
Explain left outer join and right outer join?
what information is maintained within the msdb database? : Sql server administration
What is difference between equi join and inner join?
What is used to replicate sessions between instances in coldfusion clusters?
What does it mean to be in union?
can any body tell me how to know the password of current user in sql server
Give the query of getting last two records from the table in SQL SERVER?
