AWS Redshift Alter Table Drop Constraint
The RazorSQL Redshift alter table tool includes a Drop Constraint option for dropping a constraint from an AWS Redshift database table. The drop constraint function allows the user to enter a constraint to drop from the table. The tool then generates the appropriate alter table drop constraint DDL command for dropping the constraint from the table.
Listed below is an example of the DDL generated by the Redshift Alter Table Drop Constraint tool:
ALTER TABLE sample.public.project DROP CONSTRAINT test_const
Below is a screen shot of the drop constraint function of the Redshift alter table tool.