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 you any body tell me the difference between candidate
key and primary key

Answer Posted / prasad

There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the service pack installed? : sql server database administration

1065


What are the types of ssrs?

149


What is a performance monitor?

1024


How many levels of sp nesting are possible?

1069


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1010


Create and insert into temp table in sql server?

1084


What are the types of resultset?

1015


Explain a differential backup?

1064


plss anybody specify tha constrian management system in dbms

2208


What is correlated subquery in sql server?

1127


what is nonclustered index

1005


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060


How to modify the underlying query of an existing view?

1030


What do you understand by mirroring and mention the advantages of the mirroring?

1117


Explain different types of self contained sub query?

1107