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 vote117 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
6 votes135 views1 answer
Oracle rank
SQL
3 votes150 views5 answers
Foreign keys
SQL
0 vote138 views1 answer
Postgresql replace html tags from string
SQL
4 votes141 views1 answer
List tables sqlite
SQL
0 vote143 views1 answer
MySQL import data from large CSV file
SQL
16 votes156 views3 answers
Order by sql query
SQL
-1 vote133 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote131 views1 answer
Oracle index partition
SQL
0 vote238 views1 answer
Sql server query all database objects
SQL