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

1 vote157 views2 answers
Oracle 18c xe ORA-65096
SQL
12 votes124 views3 answers
Install sqlite driver ubuntu
SQL
13 votes134 views2 answers
Get tables in database sql
SQL
0 vote162 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote126 views1 answer
Mysqli connect
SQL
5 votes142 views4 answers
Upload database mysql command line
SQL
1 vote179 views1 answer
Find size of all DB's postgres
SQL
6 votes191 views2 answers
Non relational database
SQL
2 votes156 views1 answer
Revokeprivileges mysql
SQL
1 vote157 views1 answer
Oracle activate job
SQL