How many Primary keys can have in a table?

DWQA Questions › Category: SQL › How many Primary keys can have in a table?
0 Vote Up Vote Down
Editor Staff asked 9 months ago

How many Primary keys can have in a table?

  1. Only 1
  2. Only 2
  3. Depends on no of Columns
  4. Depends on DBA
Question Tags:
1 Answers
0 Vote Up Vote Down
Editor Staff answered 9 months ago

A-Only 1
Explanation: The primary key can consist of a single or combination of the field that uniquely identifies each record in a table. It cannot be null or empty. A table may have duplicate columns, but it can contain only one primary key