Interested to Buy Any Domain ? << Click Here >> for more details...
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 are triggers? How do you invoke a trigger on demand?
What is a functions and types in sql server?
How to delete an existing row with delete statements in ms sql server?
Explain system rowset functions?
What is create statement?
How to enter binary string literals in ms sql server?
what do you understand by change data capture?
Explain how to maintain a fill factor in existing indexes?
Find first and last day of current month in sql server
What number aggregate functions are accessible there in sql?
Explain ms sql server reporting services vs crystal reports?
Some queries related to SQL
What are different types of database indexes?
What is the difference between locking and multi-versioning?
What is the datatype of rowid?
