Destructive Operations
ALTER TABLE ... DROP CONSTRAINT
ALTER TABLE orders DROP CONSTRAINT orders_customer_id_fkey;What this does
A brief catalog change, but it removes an integrity guarantee (a FOREIGN KEY, CHECK, or UNIQUE) that application code may be relying on implicitly.