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
How do I clean up sql server transaction log?
What is the use of tempdb? What values does it hold?
What is sql server agent and what are the two modes of authentication in sql server?
How to return the top 5 rows from a select query in ms sql server?
How many replicas are maintained for each SQL Azure database?
What can be used instead of trigger?
What is database dimension? : sql server analysis services, ssas
How sql server enhances scalability of the database system?
What is difference between group by and having?
Difference between Sql server reporting services and Crystal reports?
What are the benefits of filtered indexes?
If no size is defined while creating the database, what size will the database have?
What are the advantages of passing name-value pairs as parameters?
What is query parameter in ssrs?
How can sql server instances be hidden?
