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 vote92 views1 answer
Sub blocks in sql
SQL
1 vote94 views1 answer
Postgres grant read only access to database
SQL
0 vote100 views1 answer
Authentication in sql server
SQL
0 vote105 views1 answer
Check index sql server
SQL
0 vote102 views1 answer
Add multiple field in table sql
SQL
4 votes113 views3 answers
Sql drop primary key
SQL
0 vote99 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote107 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote104 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote122 views3 answers
Classement rang mysql 7
SQL