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
List few advantages of stored procedure.
What are the limitations in ssrs on sql server express edition?
What is surrogate key? : sql server analysis services, ssas
Define a cross join?
How do I clean up sql server transaction log?
What is spid in sql server profiler?
Why I have to use stored procedures?
What is 2nf normalization form?
What are the types of subquery?
Which joins are sql server default?
What are the properties of sub-query?
What are the different types of backups that exist?
What are audit control procedures?
What is the difference between SQL notification and SQL invalidation?
What is the chart in report?