can you any body tell me the difference between candidate key and primary key

can you any body tell me the difference between candidate
key and primary key

Question Posted / hari

4 Answers
8391 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can you any body tell me the difference between candidate key and primary key..

Answer / vani

A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.

Is This Answer Correct ?

6 Yes

0 No

can you any body tell me the difference between candidate key and primary key..

Answer / arijit

A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.

Is This Answer Correct ?

2 Yes

1 No

can you any body tell me the difference between candidate key and primary key..

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

can you any body tell me the difference between candidate key and primary key..

Answer / pooja

A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.

candidate key:All that fields which can be selected as
primary key are called candidate keys.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer