Answer Posted / praveen
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 ? | 4 Yes | 6 No |
Post New Answer View All Answers
How do I run a trace in sql server?
can a database be shrunk with users active? : Sql server administration
What are the properties of the transaction?
What is sql server transaction log file?
Explain various data region available in ssrs with their use?
What is acid db?
How do I trace a query in sql server?
What is row-level compre?
Explain what role entity and relationship play in an ER diagram.
What is the difference between mysql and sql server?
What are different types of raid configurations? : SQL Server Architecture
What are various limitations of the views?
What is sql server database?
Do you know what are the reporting services components?
How can we determine what objects a user-defined function depends upon?
