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

15 votes177 views4 answers
How to get all tables in sql
SQL
2 votes192 views1 answer
Merge firstname and lastname in sql oracle
SQL
5 votes178 views1 answer
Oracle scan source ddl
SQL
10 votes177 views4 answers
Mysql one week ago
SQL
-2 votes175 views1 answer
Create trigger syntax
SQL
0 vote182 views1 answer
Exec procedure oracle
SQL
1 vote179 views1 answer
Sql server update column based on another table
SQL
0 vote200 views1 answer
The fetch keyword oracle
SQL
0 vote191 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote171 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL