Alter table drop check constraint from a table

PostreSQL tutorial – Remove check constraint

Remove check constraint from table

How to remove check constraint from a table. Drop constraint syntax and example.

Syntax

ALTER TABLE table_name 
DROP CONSTRAINT constraint_name;

Example

ALTER TABLE customers 
DROP CONSTRAINT ch_first_name;

Alter table |
Drop table