AWS Redshift Alter Table Drop Primary Key
The RazorSQL Redshift alter table tool includes a Drop Primary Key option for dropping a primary key constraint from a Redshift database table. The drop primary key tool generates the appropriate alter table drop 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 Primary Key tool:
ALTER TABLE sample.public.project DROP CONSTRAINT project_pkey
Below is a screen shot of the Redshift drop primary key tool contained within the alter table tool.