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 vote259 views1 answer
Date datatype in livesql
SQL
0 vote240 views1 answer
Power bi find all ids not in other tables
SQL
1 vote246 views1 answer
Oracle grant select on schema
SQL
0 vote254 views1 answer
Mysql add to number
SQL
0 vote235 views1 answer
Unique element in sql
SQL
0 vote261 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
3 votes262 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote228 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote234 views1 answer
How to create an SQL save method in ruby
SQL
0 vote226 views1 answer
Mariadb LOAD DATA INFILE
SQL