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 vote356 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote307 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote383 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote342 views3 answers
Get free card roblox
SQL
0 vote352 views1 answer
Sqlite to csv statement
SQL
1 vote364 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote342 views1 answer
Alter database name script
SQL
0 vote321 views1 answer
Postgresql newline character
SQL
0 vote373 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote409 views3 answers
Constraint sql
SQL