Thursday, December 26, 2013

What is the difference between Candidate Key, Alternate Key, and Composite Key

What is Candidate Key, Alternate Key, and Composite Key
Candidate Key :
A Candidate Key is one that can uniquely identify each row of a table. Generally a candidate key becomes the Primary Key of the table. 

Alternate Key:
If the table has more than one Candidate Key, one of them will become the Primary Key, and the rest are called Alternate Keys.

Composite Key : 
A key formed by combining at least two or more columns is called Composite Key.

--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.

Featured Post from this Blog

How to compare Current Snapshot Data with Previous Snapshot in Power BI

How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...

Popular Posts from this Blog