How many Primary keys can have in a table?

Category: SQLHow many Primary keys can have in a table?
Editor">Editor Staff asked 2 years 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
1 Answers
Editor">Editor Staff answered 2 years 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