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 does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What are cascading parameters in ssrs reports?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How to concatenate two strings in SQL Server.
Can you explain what are commit and rollback in sql?
Why would you use sql agent?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What are the Advantages of using CTE in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is the use of partition by in sql server?
Why Master database is required?
Explain nested join?
What is the need for group functions in sql?
How to check parameter value in stored procedure sql server?
What is side by side migration in sql server?
