Mentions the difference between unique key and primary key?


Warning: Trying to access array offset on false in /home3/indiakep/public_html/wp-content/plugins/dw-question-answer/inc/Template.php on line 8
All Questions › Category: Database › Mentions the difference between unique key and primary key?
0 Vote Up Vote Down
chetan shidling asked 5 years ago

I need short information.

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

Unique Key

  1. The unique key can have a NULL value.
  2. Each table can have more than one unique key.

 
Primary Key

  1. The primary key cannot have a NULL value.
  2. Each table can have only one primary key.