/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

12 votes403 views4 answers
How to drop all tables in postgresql
SQL
0 vote354 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
7 votes343 views6 answers
Group_concat mysql
SQL
6 votes365 views1 answer
How to get the size of the database in postgresql
SQL
0 vote340 views1 answer
Excute raw query
SQL
15 votes390 views4 answers
Create table if not exists sql
SQL
1 vote365 views1 answer
Sql check roles
SQL
1 vote349 views1 answer
Mysql view current queries
SQL
0 vote376 views1 answer
Mysql case when on date
SQL
0 vote348 views1 answer
Oracle sql date winter time
SQL

Share