juniorT-SQL

What is PRIMARY KEY?

Updated May 17, 2026

Short answer

Uniquely identifies each row.

Deep explanation

Ensures uniqueness and enforces entity integrity.

Real-world example

Employee ID uniquely identifying records.

Common mistakes

  • Using nullable primary keys.

Follow-up questions

  • Can PK be composite?
  • Is PK indexed?

More T-SQL interview questions

View all →