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 vote329 views1 answer
SQL date part only of datetime
SQL
0 vote331 views1 answer
Sql server get date of previous sunday
SQL
0 vote319 views1 answer
Knex last insert id mysql
SQL
6 votes326 views1 answer
Phpmyadmin password root
SQL
1 vote312 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote334 views3 answers
Execute sp in sql server
SQL
0 vote282 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
12 votes318 views2 answers
Delete all nodes neo4j
SQL
11 votes330 views1 answer
Mysql text type max length
SQL
1 vote339 views1 answer
SQL query to get all table records count from a database
SQL