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
- 5134 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 subquery in sql?
What are the different types of join?
Explain relational data?
What are commonly used odbc functions in php?
What are the aggregate and scalar functions?
What is the purpose of forms?
How do you test your database? : sql server database administration
what is the sql equivaent of the dataset relation object ?
What is a rownum?
What is tempdb database? : SQL Server Architecture
Does partitioning help performance?
How do you use a subquery to find records that exist in one table and do not exist in another?
How to create a user to access a database in ms sql server using "create user" statements?
What is purpose of normalization?
How to defragment table indexes?
