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 vote159 views1 answer
Mysql database hyphen
SQL
0 vote153 views2 answers
Tsql row number
SQL
1 vote149 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote149 views1 answer
Show size of all tables postgres
SQL
62 votes333 views8 answers
Mysql add column
SQL
0 vote137 views1 answer
Dnsmasq.conf location macos
SQL
4 votes117 views1 answer
Oracle sleep
SQL
5 votes173 views2 answers
Postgresql insert select
SQL
0 vote172 views1 answer
How to get nth number in sql
SQL
0 vote166 views3 answers
Fetlife
SQL