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
Which are the olap features?
What is the impact on other user sessions when creating indexes?
Differentiate between a primary key and a unique key.
Explain different backup plans?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How can I change procedure name in sql server?
How to concatenate two strings in SQL Server.
How exceptions can be handled in sql server programming?
Can you pass expressions to stored procedure parameters?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What are scalar functions?
What is difference between cte and view?
 Explain what is sql override for a source taLle in a mapping?
wat wil hapn if we give the both read and deny read permission to user?
How to search for a string in all stored procedure in sql server?
