Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Add foreign key

Link rows to a parent table with referential integrity.

Back to sheetBrowse commands
Sign in to save
Section: Indexes and Constraints

Add foreign key

sql
sql
ALTER TABLE orders
ADD CONSTRAINT orders_customer_fk
FOREIGN KEY (customer_id)
REFERENCES customers (customer_id)
ON DELETE RESTRICT;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Indexes and Constraints
Add primary key
Define a primary key after table creation.
OpenIn sheetsqlsame section
Add unique constraint
Ensure unique values through a table constraint.
OpenIn sheetsqlsame section
Create index
Add a basic B-tree index to speed lookups.
OpenIn sheetsqlsame section
Create index concurrently
Build an index with reduced write blocking.
OpenIn sheetsqlsame section
Create unique index
Enforce uniqueness with an index.
OpenIn sheetsqlsame section
Create partial index
Index only a subset of rows.
OpenIn sheetsqlsame section