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

0 vote334 views1 answer
Including parameters in OPENQUERY
SQL
0 vote356 views1 answer
Sql dmv to capture updates
SQL
0 vote337 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote406 views1 answer
Sql random sampling per group
SQL
0 vote353 views2 answers
Sql query for getting details by id
SQL
0 vote326 views1 answer
Time in sql server
SQL
12 votes386 views2 answers
Insert multiple rows from another table sql
SQL
0 vote339 views1 answer
Update using case in mysql
SQL
0 vote345 views1 answer
How to find sql server name
SQL
0 vote344 views1 answer
Power query case when
SQL