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

3 votes252 views1 answer
Oracle revoke grant
SQL
5 votes225 views1 answer
Postgres upsert
SQL
0 vote243 views1 answer
SQL Server format datetime
SQL
2 votes264 views1 answer
Guid to string sql
SQL
0 vote291 views1 answer
Sql script to remove default from column
SQL
5 votes258 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
1 vote256 views1 answer
Oracle duration between timestamps
SQL
0 vote237 views1 answer
T sql return on letters only
SQL
0 vote252 views1 answer
Oracle search columns in schema
SQL
3 votes275 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL