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

2 votes214 views2 answers
Useradd postgres
SQL
19 votes216 views5 answers
Change column name mysql command line
SQL
0 vote235 views1 answer
Calculate age in sql
SQL
2 votes276 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
3 votes224 views2 answers
Oracle drop column
SQL
2 votes207 views1 answer
Select from array in psql
SQL
1 vote203 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote222 views1 answer
Use of now() in mysql
SQL
0 vote235 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote223 views1 answer
Sql commands in android
SQL