Skip to content

Glossary: SQL Beyond the Basics

Primary key

Also written: PRIMARY KEY, INTEGER PRIMARY KEY

The column or columns that identify each row; no two rows share it and it can't be NULL. A column declared INTEGER PRIMARY KEY numbers itself in SQLite.

Where the book teaches it

Related terms

Surrogate keyComposite keyForeign key