Mysql drop table cascade

SET FOREIGN_KEY_CHECKS = 0;
drop table if exists <your_1st_table>;
drop table if exists <your_2nd_table>;
SET FOREIGN_KEY_CHECKS = 1;

Source: stackoverflow.com

Alter table add on delete cascade mysql

ALTER TABLE TABLEName
drop CONSTRAINT FK_CONSTRAINTNAME;

ALTER TABLE TABLENAME
ADD CONSTRAINT FK_CONSTRAINTNAME
    FOREIGN KEY (FId)
    REFERENCES OTHERTABLE
        (Id)
    ON DELETE CASCADE ON UPDATE NO ACTION;

Source: stackoverflow.com

Similar codes

1 vote114 views1 answer
Join first name and last name sql
SQL
12 votes119 views4 answers
How to take database dump in postgresql
SQL
0 vote76 views1 answer
Check sql query executed wp
SQL
9 votes118 views6 answers
Replace sql
SQL
0 vote73 views2 answers
Spring properties file for db
SQL
3 votes115 views4 answers
Stop MySQL
SQL
0 vote128 views1 answer
Oracle drop type
SQL
0 vote128 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote126 views1 answer
Mysql select row max date
SQL
19 votes116 views6 answers
What is mySQL
SQL