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
Comment,Datatypes are unlimited
What is log shipping?
What is history table in sql server?
Explain the difference between primary keys and foreign keys?
What is inner join? Explain with an example?
How to download and install microsoft sql server management studio express?
What are the types of subscriptions in SQL Server replication?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
do you know how to configure db2 side of the application? : Sql server database administration
How to set the current database in ms sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is a bit datatype?
What is an index in sql?
How to Sync Two SQL Azure Databases?
What is tablix?
