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 vote288 views1 answer
Pass array parameter to stored procedure c#
SQL
9 votes538 views2 answers
Current date in postgresql minus 1 day
SQL
5 votes269 views1 answer
Sql first day of current year
SQL
15 votes303 views3 answers
Postgresql change column type
SQL
5 votes316 views1 answer
Mysql add user with all privileges
SQL
0 vote262 views1 answer
How to check replication lag in mySQL
SQL
1 vote299 views1 answer
Mysql show queries running
SQL
3 votes279 views2 answers
Oracle synonym
SQL
0 vote287 views2 answers
How to use aggregate functions in sql
SQL
0 vote283 views1 answer
T sql check active deadlock
SQL