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...

can primery key be a non clustered index?

Answer Posted / hiral bhatt

No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)

Is This Answer Correct ?    11 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by stored techniques? How would we use it?

1022


What is measure group, measure? : sql server analysis services, ssas

999


How to create and drop temp table in sql server?

1047


What is database replication?

1130


Explain steps of normalization?

991


What is subquery in sql?

1057


What is log cache in sql server?

1029


Can a table have 2 primary keys?

977


What is the openxml statement in sql server?

1063


What is plan freezing?

959


What stored by the model?

1047


What is a group function explain with an example?

978


Define msdb database?

1008


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1024


What is sql server used for?

1038