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 vote189 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote224 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote200 views1 answer
Postgres meta command to show all rows in table
SQL
11 votes223 views2 answers
Sql rank
SQL
0 vote195 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
1 vote185 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote174 views6 answers
Unique key in sql
SQL
0 vote203 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote227 views2 answers
Changes not showing on website server odoo
SQL