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 vote245 views1 answer
Store query result in variable sql
SQL
10 votes281 views1 answer
User_dependencies
SQL
0 vote304 views2 answers
Identity syntax in sql
SQL
5 votes285 views1 answer
Oracle list days between two dates
SQL
4 votes279 views2 answers
Oracle unlock user
SQL
4 votes275 views1 answer
Refresh postgres config
SQL
2 votes287 views3 answers
Sql interview query questions
SQL
17 votes291 views6 answers
Change column name in sql
SQL
0 vote221 views1 answer
Sqlalchemy filter relationship
SQL
48 votes315 views3 answers
Psql create database
SQL