/SQL/DROP TABLes regardless of constraints

DROP TABLes regardless of constraints

DROP TABLes regardless of constraints

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE <table_name>

-- if you want to later add or modify foreign keys
SET FOREIGN_KEY_CHECKS = 1;

1

Drop table with constraints

1. 'First Drop contrstraints like this'
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;
2. 'Then drop table'
DROP TABLE table_name;

0

Similar codes

0 vote210 views1 answer
Mysql table variables
SQL
0 vote232 views1 answer
Count in sql and diff
SQL
5 votes211 views2 answers
To date oracle
SQL
1 vote200 views1 answer
Drop table if exists oracle
SQL
44 votes330 views4 answers
Mysql alter table add column first
SQL
2 votes219 views2 answers
Sqlite_busy: database is locked
SQL
1 vote215 views1 answer
Mysql not supported auth mode
SQL
0 vote195 views1 answer
Php delete database
SQL
4 votes218 views1 answer
Sql quote in string
SQL
0 vote260 views1 answer
Get foreign table names mysql
SQL

Share