How to drop a constraint in Redshift database

Identify the constraint that you would like to drop using below sql and copy the constraint name.

select * from information_schema.table_constraints where table_name = 'tablename';

Below is the command to drop a table constraint from a Redshift table where constraint_name is the name of the constraint that needs to be dropped.

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

See also  How to get day of week in Redshift database