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 vote170 views1 answer
Generate sql from specific migration ef core
SQL
1 vote127 views1 answer
Oracle list data files
SQL
0 vote129 views1 answer
Alasql delete column
SQL
0 vote131 views1 answer
Oracle sql procedure return value
SQL
0 vote123 views1 answer
Sql convert datetime to year
SQL
1 vote131 views1 answer
Count mysql server db tables
SQL
1 vote119 views1 answer
Using SQL in rails migration
SQL
3 votes120 views2 answers
To_char oracle
SQL
4 votes122 views1 answer
Select nls_date_format
SQL
0 vote133 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL