xxxxxxxxxx
ALTER TABLE jobs DROP FOREIGN KEY constraint_name
xxxxxxxxxx
ALTER TABLE table_name
DROP FOREIGN KEY constraint_name;
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
SET FOREIGN_KEY_CHECKS = 0;
drop table if exists customers;
drop table if exists orders;
drop table if exists order_details;
SET FOREIGN_KEY_CHECKS = 1;
xxxxxxxxxx
ALTER TABLE Business ADD CONSTRAINT Government_Compliance_FK FOREIGN KEY
(Government_Compliance_FK_ID) REFERENCES Government_Compliance(Government_Compliance_ID) ON DELETE RESTRICT ON UPDATE CASCADE;
ALTER TABLE Business DROP FOREIGN KEY Government_Compliance_FK;