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 / raju

No. If a table have primary key column automatically it is
clustered index. if a table have other than primary key
it have non clustered index. so answer of the question is it
doesn't support non clustered index in the primary key column

Is This Answer Correct ?    22 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is correlated subquery in sql server?

1015


Define left outer join?

920


Can primary key be null?

878


What is extent? Types of extents?

1086


How to enable/disable indexes?

1012


Do you know how to implement service broker?

885


Why de-normalization required?

939


What are the main differences between #temp tables and @table variables and which one is preferred?

1011


Which is better statement or preparedstatement?

867


What is the difference between coalesce() & isnull()?

1047


What is identity?

947


What is a virtual table in sql?

939


why would you use sql agent? : Sql server database administration

1114


Define msdb database?

972


What authentication modes does sql server support?

1017