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
- 4876 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
How network traffic be reduced by using the stored procedure?
Can we do dml on views?
What is 2nf example?
What is user-defined function?
How to use subqueries with the exists operators in ms sql server?
How can you check the level of fragmentation on a table?
Can we use trigger new in before insert?
Name the different type of indexes in sql?
Define outer join?
What is the difference between system objects and user objects?
What is the federation in sql azure?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Determine how to use the inserted and deleted pseudo tables?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
