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
Where the sql logs gets stored?
How to find the list of fixed hard drive and free space on server?
How will you monitor replication latency in transactional replication? : sql server replication
How to make conditional sum in ssrs?
What is extent? Types of extents?
What are the differences between decimal and float in ms sql server?
what are the different stages of Report Processing?
What is the parse query button used for?
What is a view and what are its advantages?
How to achieve Paging of records in SQL SERVER?
If a stored procedure is taking a table data type, how it looks?
What do you mean by stored techniques? How would we use it?
What is a trigger and its types?
How to drop an existing stored procedure in ms sql server?
Explain try...catch with sql server?
