Thursday, January 17, 2008

What is Canditate Key?

A table which is having more that one combination of column that could uniqly identify the rows in a table. Each combination is a canditate key.
Eg. In the supplier table SupplierID, Supplier name are the canditate key but we can pick up only the supplierID as a primary key.

No comments: