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
what are the new features introduced in sql server 2000? : Sql server database administration
What are audit control procedures?
How to read data in a table with "select" statements?
can SSRS reports Cache results?
Why variables called the most powerful component of ssis?
What is the beast way to write CTE in SQL Server ?
What is openxml in sql server?
Does a server store data?
What is the sql case statement used for? Explain with an example?
Do you know what are the steps to process a single select statement?
What does the update command do?
Would you store your query in a ssrs report or a database server? State the reason why?
What is sql server agent and what are the two modes of authentication in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
Is it possible in sql table to have more than one foreign key?