How to Drop an Index in Redshift
This article deals with removing primary key, unique keys and foreign key constraints from a table. Please refer to Creating Indexes to understand the different treatment of indexes/constraints in Redshift.
To remove a constraint from a table, use the
ALTER TABLE.. DROP CONSTRAINT command:
-- If you don't know the name of the constraint, you can look it up using: SELECT constraint_name, constraint_type FROM information_schema.table_constraints WHERE table_name='your_table_name'; -- Then drop the constraint using the ALTER TABLE command: ALTER TABLE DROP CONSTRAINT constraint_name;