AWS Redshift Alter Table Add Constraint

The RazorSQL alter table tool includes an Add Constraint option for adding check constraints to Redshift database tables. The add constraint function allows the user to add a constraint name and a constraint condition. The tool then generates the appropriate alter table command for adding the constraint to the table.

Listed below is an example of the DDL generated by the Redshift Alter Table Add Constraint tool:

ALTER TABLE sample.public.project ADD CONSTRAINT PROJECT_CONST CHECK (pnumber > 0)

Below is a screen shot of the add constraint function of the Redshift alter table tool.

Redshift Add Constraint