Answer Posted / devendra sharma
Yes it is possible that a primary key can be non clustered
create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)
create clustered index abc_clustered on abc (vid)
now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.
Give it a try if you don't belive......
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
what are the critical issues you have resloved in your company
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is ms sql server service broker?
What is tablix?
How do you know if sql server is running on your local system?
How we can compare two database data?
Why people hate cursor?
What is the difference between grant and with grant while giving permissions to the user?
what is a schema in sql server 2005? : Sql server database administration
How to fine-tune reports?
What is efficiency data?
How to stop log file growing too big?
What objects does the fn_my_permissions function reports on? : sql server security
When cursors are useful?
What is db stored procedure?
