What is a PRIMARY KEY?

Question

Accepted Answer

A PRIMARY KEY enforces two rules at once: every value must be unique across all rows, and no value may be NULL. You can only define one primary key per table, though it can span multiple columns (a composite key). Most databases automatically create an index on the primary key column, but the key itself is a constraint, not an index.