FOREIGN KEY / REFERENCES

A foreign key (FOREIGN KEY ... REFERENCES) is a column whose values must exist in the primary key of another table. The database then refuses to insert or delete rows that would break the reference: this is referential integrity.

Example

client_id INTEGER REFERENCES clients(id)

Related concepts

The whole glossary