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.

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

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