- Remove the constraint column from any views in which the column appears using the REPLACE VIEW statement and omitting the column name in the new view.
- Drop indexes that include the constraint column, then recreate the indexes without the column.
- Remove the constraint column from all tables in which the column appears, using the ALTER TABLE statement. For example:
ALTER TABLE table_name DROP constraint_column_name ;