ALTER TABLE ReferencingTable DROP CONSTRAINT fk__ReferencingTable__MainTable; ALTER TABLE ReferencingTable ADD CONSTRAINT fk__ReferencingTable__MainTable FOREIGN KEY (pk_col_1) REFERENCES MainTable (pk_col_1) ON DELETE CASCADE;