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

List few advantages of stored procedure.

972


What are the limitations in ssrs on sql server express edition?

186


What is surrogate key? : sql server analysis services, ssas

1095


Define a cross join?

988


How do I clean up sql server transaction log?

1046


What is spid in sql server profiler?

1082


Why I have to use stored procedures?

1017


What is 2nf normalization form?

1112


What are the types of subquery?

1024


Which joins are sql server default?

979


What are the properties of sub-query?

1061


What are the different types of backups that exist?

1148


What are audit control procedures?

973


What is the difference between SQL notification and SQL invalidation?

1154


What is the chart in report?

158