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 votes276 views1 answer
SQL column name Postgre
SQL
0 vote278 views1 answer
Contact mysql column field
SQL
0 vote277 views1 answer
Azure sql server check foreign key
SQL
0 vote289 views1 answer
Implicit inner join table alias
SQL
3 votes294 views5 answers
Foreign keys
SQL
0 vote292 views1 answer
Sql server list table sizes
SQL
11 votes282 views5 answers
How to install sqlite3 python
SQL
2 votes260 views1 answer
Mysql sysdate
SQL
6 votes280 views2 answers
How to copy data in sql
SQL
3 votes273 views3 answers
Django.db.utils.OperationalError: no such table:
SQL