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

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 ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of table?

1031


What is exclusive locks?

1016


Can you create a logon trigger in sql server 2005 express edition?

1128


Explain for xml explicit mode?

1029


What are the components of sql server service broker?

1070


What is store procedure?

1118


What is store procedure? When do you use?

990


How do I view a trc file?

981


How do I debug a stored procedure in sql server?

1181


Explain what is meant by replication of database?

1106


Can sub report data source be different from that of the parent report?

149


How do you open a cluster administrator?

1099


Explain about nested stored procedure?

1084


Explain the flow of creating a cube? : sql server analysis services, ssas

1104


What are the components of dbms?

999