AWS Redshift Alter Table Drop Foreign Key
The RazorSQL Redshift alter table tool includes a Drop Foreign Key option for dropping a foreign key constraint from an AWS Redshift table. The drop foreign key tool generates the appropriate alter table drop constraint DDL command for dropping the key from the table.
Listed below is an example of the DDL generated by the Redshift Alter Table Drop Foreign Key tool:
ALTER TABLE sample.public.project DROP CONSTRAINT project_dnum_fkey;
Below is a screen shot of the drop foreign key tool contained within the Amazon Redshift alter table tool.