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 types of table?
What is exclusive locks?
Can you create a logon trigger in sql server 2005 express edition?
Explain for xml explicit mode?
What are the components of sql server service broker?
What is store procedure?
What is store procedure? When do you use?
How do I view a trc file?
How do I debug a stored procedure in sql server?
Explain what is meant by replication of database?
Can sub report data source be different from that of the parent report?
How do you open a cluster administrator?
Explain about nested stored procedure?
Explain the flow of creating a cube? : sql server analysis services, ssas
What are the components of dbms?