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

Primary key is also known as clusterd index which is
physical structure .And noncluster index is logical
structure .

therefore Primary key cant be a nonclustered index. and
when we are creating primary key on a table system
understands it as creation of clustered index.

this is the reason one table can have one primary key

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2256


What is the process of normalising?

1049


How to provide default values to function parameters?

1224


How to delete duplicate rows in sql server?

1156


What are system databases in ms sql server?

1126


Define outer join?

1048


What does executeupdate return?

1034


What is the purpose of linked server configuration in sql server?

1096


Why use sub query in sql server and list out types of sub queries?

1060


How secure is sql server database?

1068


Why do we use stored procedures in sql server?

999


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

940


What is difference between count (*) and count 1?

978


What options are available to audit login activity? : sql server security

1202


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

994