Interested to Buy Any Domain ? << Click Here >> for more details...
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 start sql server agent automatically?
Can I save my report as html, excel or word? : sql server management studio
How you trouble shoot when any job fails
How do I start sql server 2016?
A trigger can reference objects outside the current database? State true or false.
how would you improve etl (extract, transform, load) throughput?
Is the primary key column of a table an index in ms sql server?
What are cursors stored procedures and triggers?
How to configure and test odbc dsn settings?
How to link tables in sql server?
Which table keeps the locking information?
What happens if null values are involved in bitwise operations?
What is the difference between DATETIME2 and DATETIME?
Difference between uniqe index and uniqe constraint?
What is temporal table?
