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 vote213 views1 answer
Cross schema query oracle 2 users
SQL
1 vote228 views1 answer
Oracle sql pad left zeros
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote200 views1 answer
Mysql select where field is a value
SQL
0 vote218 views1 answer
Mysql sql.gz
SQL
1 vote210 views1 answer
Oracle sql average
SQL
0 vote202 views1 answer
T-sql check if data exists
SQL
1 vote197 views1 answer
Search for tables with name postgresql
SQL
0 vote203 views1 answer
Sql add calculated column
SQL
0 vote207 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL