/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

3 votes340 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote319 views2 answers
Mysql slave status
SQL
0 vote332 views1 answer
Show create table in postgresql
SQL
0 vote368 views1 answer
How to check database engine in mysql
SQL
0 vote342 views1 answer
Max mysql
SQL
18 votes343 views6 answers
Creating table in MySQL
SQL
0 vote390 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote334 views1 answer
Sql server manager close connection
SQL
0 vote366 views1 answer
Sql select sum group by id laravel join
SQL
3 votes360 views2 answers
Sql not contains
SQL

Share