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 vote174 views1 answer
Error code 1451 sql
SQL
1 vote198 views1 answer
Sql oracle update multiple rows
SQL
0 vote166 views2 answers
Mysql insert into multiple tables
SQL
4 votes149 views4 answers
Sqlite describe table
SQL
0 vote149 views1 answer
Sql server set complex constraints
SQL
5 votes146 views2 answers
Copy data from one database to another
SQL
0 vote188 views1 answer
Convert rows into columns in oracle
SQL
0 vote164 views1 answer
Mssql + bit + in python orm
SQL
0 vote150 views1 answer
Sql select by content lenght
SQL
7 votes152 views1 answer
Set sequence value oracle
SQL