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 new features introduced in sql server 2000? : Sql server database administration

975


What are audit control procedures?

1034


How to read data in a table with "select" statements?

1027


can SSRS reports Cache results?

155


Why variables called the most powerful component of ssis?

1122


What is the beast way to write CTE in SQL Server ?

1093


What is openxml in sql server?

1219


Does a server store data?

953


What is the sql case statement used for? Explain with an example?

1039


Do you know what are the steps to process a single select statement?

1017


What does the update command do?

1173


Would you store your query in a ssrs report or a database server? State the reason why?

157


What is sql server agent and what are the two modes of authentication in sql server?

1108


how to determine the service pack currently installed on sql server? : Sql server database administration

1024


Is it possible in sql table to have more than one foreign key?

1090