Answer Posted / hiral bhatt
No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
What do you mean by stored techniques? How would we use it?
What is measure group, measure? : sql server analysis services, ssas
How to create and drop temp table in sql server?
What is database replication?
Explain steps of normalization?
What is subquery in sql?
What is log cache in sql server?
Can a table have 2 primary keys?
What is the openxml statement in sql server?
What is plan freezing?
What stored by the model?
What is a group function explain with an example?
Define msdb database?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is sql server used for?