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 vote277 views1 answer
Site:av.ru "files"
SQL
0 vote187 views1 answer
How to select even id in sql
SQL
0 vote174 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
-1 vote181 views2 answers
Sql query examples
SQL
0 vote180 views1 answer
Create schema sql server
SQL
0 vote260 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote159 views3 answers
Java.sql.sqlexception: access denied for user
SQL
11 votes175 views1 answer
Mysql text type max length
SQL
0 vote195 views1 answer
Including parameters in OPENQUERY
SQL
0 vote173 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL