Databaseseasy

Primary key vs unique constraint: what’s the difference?

Answer

A primary key uniquely identifies a row and typically implies NOT NULL plus a single main identifier per table. A unique constraint also enforces uniqueness but you can have multiple unique constraints and they may allow NULLs depending on the DB.

Related questions

Databases

Autocommit vs explicit transactions: when does it matter?

#database#transactions#autocommit

Databases

OLTP vs OLAP: what’s the difference?

#database#oltp#olap

Databases

Denormalization: when might you do it and what’s the trade‑off?

#database#denormalization#performance

Databases

Partitioning vs sharding: what’s the difference?

#database#partitioning#sharding

Databases

Isolation levels: what’s the difference between Read Committed, Repeatable Read, and Serializable?

#database#transactions#isolation

Databases

Deadlock: what is it and how do databases resolve it?

#database#transactions#locks