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

3 votes335 views1 answer
V$session not found in oracle
SQL
15 votes390 views6 answers
Laravel db transaction
SQL
0 vote399 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote353 views2 answers
Mysql error 1215
SQL
1 vote367 views1 answer
Does insert into overwrite sql
SQL
-1 vote408 views4 answers
Sql view postgresql
SQL
0 vote368 views2 answers
Alter table add multiple columns mysql
SQL
49 votes461 views6 answers
Install mysql ubuntu
SQL
13 votes370 views3 answers
Sql select from multiple tables without join
SQL
0 vote366 views1 answer
Sql add calculated column
SQL