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 vote290 views2 answers
Sql where is not number
SQL
0 vote303 views1 answer
Ignore case in string sql
SQL
23 votes308 views4 answers
Sql server substring
SQL
0 vote320 views1 answer
Sql query contains multiple ids
SQL
0 vote310 views1 answer
Max mysql
SQL
6 votes298 views2 answers
WHERE value IS sql
SQL
0 vote352 views1 answer
Sql server phone constraint
SQL
1 vote308 views1 answer
Show all event schedular on mysql
SQL
0 vote317 views1 answer
Oracle array
SQL
0 vote276 views1 answer
Sql random decimal
SQL