Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedBasic SELECT

Drop a constraint

SQL

ALTER TABLE employees 
DROP CONSTRAINT unique_email;

Tested against PostgreSQL 16

Note

“Drops the constraint by its name. If you didn\'t name it, PostgreSQL generated one (like employees_email_key).