Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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?

945


What is the exact numeric data type in sql?

960


What is the osql utility?

909


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453


In which format does an image save in SQL Server database ?

946


What are the different types of replication are there in sql server 2000?

982


What is shared lock?

834


How to create a user to access a database in ms sql server using "create user" statements?

912


How do I start sql server 2016?

857


Explain about system database?

999


Can a rule be bound to any column of any data type?

911


What are the advantages of log shipping?

929


How to insert multiple rows with one insert statement in ms sql server?

1055


Is there any difference between primary key and unique with the not null condition?

886


Is INSTEAD OF trigger directly applicable to Table ?

958