What is a candidate key ?

[educaindia358]

Keep Posting like this.

[pankaj86]

Candidate key is a key which have all the attribute of primary key but not primary key.

[ziya.pathan]

Candidate keys are those keys which is candidate for primary key of a table. In simple words we can understand that such type of keys which full fill all the requirements of primary key which is not null and have unique records is a candidate for primary key. So thus type of key is known as candidate key. Every table must have at least one candidate key but at the same time can have several.

[liyanstech]

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys.

[mystic98]

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is special, and it is called the primary key. This is usually the best among the candidate keys.

When a key is composed of more than one column, it is known as a composite key.

[tyagi]

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.

Thank you!

[Somani_Realtors]

A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys.

[Sreesri]

A candidate key is a column, or set of columns.But one candidate key is unique and It is called the Primary Key.and the candidate Keys to use for identification.

[JamesMartin]

A qualifing primary key

[pxl]

These is an key combination of attributes can be uniquely use to identify the database record without referring any data.

[komal14]

A Candidate Key can be any column or a combination of columns that can qualify as unique key in database.