What are the different types of keys in the database?

All Questions › Category: Database › What are the different types of keys in the database?
0 Vote Up Vote Down
chetan shidling asked 4 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
chetan shidling answered 4 years ago

The different types of keys in the database are:
 

  1. Super key = Candidate Key + Unique Key
  2. Primary key = CustomerID
  3. Alternate Key = PanNumber
  4. Candidate Key = CustomerID and PanNumber
  5. Foreign Key – CustomerID