Difference between Unique Key and candidate key ...

Replies

Naraayanan
Posted on: 6/11/2012 8:22:44 AM

Level: Starter | Status: [Member] | Points: 25

Hi,
Check this link..
http://blog.sqlauthority.com/2009/10/22/sql-server-difference-between-candidate-keys-and-primary-key-2/

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Muhsinathk
Posted on: 6/11/2012 8:24:41 AM

Level: Bronze | Status: [Member] | Points: 25

http://www.coolinterview.com/interview/24530/

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Muhsinathk
Posted on: 6/11/2012 8:25:26 AM

Level: Bronze | Status: [Member] | Points: 25

Thank you Naraayanan

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Muhsinathk
Posted on: 6/11/2012 8:27:07 AM

Level: Bronze | Status: [Member] | Points: 25

http://dev.fyicenter.com/Interview-Questions/ORACLE-4/What_is_the_difference_between_candidate_key_un.html

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

.Netlearner
Posted on: 6/11/2012 8:28:49 AM

Level: Starter | Status: [Member] | Points: 25

A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.

A key formed by combining at least two or more columns is
called composite key.

Refer this link for further details :http://blog.sqlauthority.com/2009/10/22/sql-server-difference-between-candidate-keys-and-primary-key-2/

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Akiii
Posted on: 6/11/2012 10:19:49 AM

Level: Bronze | Status: [Member] | Points: 25

An unique key and a primary key is a type of candidate key.

Thanks and Regards
Akiii

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Muhsinathk
Posted on: 6/12/2012 12:01:21 AM

Level: Bronze | Status: [Member] | Points: 25

Thank youu

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Sriramnandha
Posted on: 6/21/2012 5:40:25 AM

Level: Starter | Status: [Member] | Points: 25

Unique Key:

Unique key Restrict Duplicate Values and Null Values.Default Non Clustered index is an Unique Key

Example:

Create table Test(Testid int constraint pk_Test unique(Testid), TestName varchar(90))

Candidate Key:

Primary Key Alternative is an Candidate Key

Regards
Srriam.R

sriram

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Gemamgall
Posted on: 6/27/2012 11:26:28 AM

Level: Starter | Status: [Member] | Points: 25

Candidate Key is a column in a table which has the ability to become a primary key.

Unique key is same as primary key but only difference is that unique key allows only one null value but primary does not allow even a single null value

Thanks and Regards,

Vinay Gandhi
www.quadtechindia.com

Muhsinathk, if this helps please login to Mark As Answer. | Reply | Alert Moderator

Difference between Unique Key and candidate key

Replies

Reply - Please login to reply

Latest Posts