Interested to Buy Any Domain ? << Click Here >> for more details...
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 does dml stand for?
Tell me what is log shipping?
What is a collation in ms sql server?
Do you know how to make remote connection in database?
How to assign new column names in a view?
Do you know what are the properties of the relational tables?
What is self contained multi valued query?
Explain the categories of stored procedure?
How do I edit a stored procedure in sql server?
How do I find the transaction log size in sql server?
Explain for xml explicit mode?
How to convert character strings into numeric values?
Why normalization is used?
What are the different authentication modes in sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
