/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

15 votes210 views5 answers
Select all tables sql
SQL
0 vote177 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote181 views1 answer
SQL Server rename foreign key constraint
SQL
2 votes141 views1 answer
Sql float to int
SQL
-1 vote188 views8 answers
Create Trigger in phpMyAdmin
SQL
8 votes176 views1 answer
Unique vs primary key
SQL
-1 vote191 views1 answer
Spring boot mysql connection properties
SQL
0 vote184 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
1 vote185 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes230 views1 answer
Sqlite3 show columns name
SQL

Share