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 vote195 views1 answer
Sql create table with references not primary key
SQL
11 votes197 views3 answers
Change column name sql server management studio
SQL
0 vote193 views1 answer
Postgres in operator with comma separated values
SQL
0 vote199 views1 answer
Apex for oracle 11g
SQL
0 vote200 views1 answer
Regex mongoose
SQL
5 votes174 views1 answer
Update sql user password
SQL
6 votes229 views3 answers
Rename column ORACLE
SQL
0 vote218 views1 answer
Nuget sqllite-net-pcl
SQL
1 vote241 views1 answer
Mysql default port
SQL
1 vote198 views1 answer
How to update date add hours in postgresql
SQL