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.
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. If you wish, please share your genuine Feedback or comments only related to this Blog Posts. It is my humble request that, please do not post any Spam comments or Advertising kind of comments, which will be Ignored.