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 is collation sensitivity? Explain different types.
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the report model project?
What is trigger and different types of Triggers?
where the connection string store in the database
How do I find the default sql server instance?
Explain cross join or cartesian product in sql?
What are system databases into sql server (2005/2008)?
In case you have filters in your report, when filters will be applied in cached report instance?
What are logical/boolean operations in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the datatype of rowid?
What is nolock?
What are the two modes of authentication in sql server?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
