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 the advantages of user-defined functions over stored procedures in sql server?
What is use of except clause? How it differs from not in clause?
How to Check if table exists in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is difference between join and natural join?
what are the three command line utilities and what are their primary functions?
How to use values from other tables in update statements in ms sql server?
How ssrs maintain security?
How to count rows with the count(*) function in ms sql server?
What guidelines should be followed to help minimize deadlocks?
What is sql server schema compare? How we can compare two database schemas?
what are the different types of replication you can set up in sql server? : Sql server database administration
How do you handle datasets larger than 50 gb?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are different types of views?
