WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / shailesh arban
Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is the exact numeric data type in sql?
What is the osql utility?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
In which format does an image save in SQL Server database ?
What are the different types of replication are there in sql server 2000?
What is shared lock?
How to create a user to access a database in ms sql server using "create user" statements?
How do I start sql server 2016?
Explain about system database?
Can a rule be bound to any column of any data type?
What are the advantages of log shipping?
How to insert multiple rows with one insert statement in ms sql server?
Is there any difference between primary key and unique with the not null condition?
Is INSTEAD OF trigger directly applicable to Table ?