/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

1 vote235 views2 answers
Sql for date greater than
SQL
0 vote222 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote230 views1 answer
Modificar tipo de dato sql server
SQL
3 votes220 views1 answer
Sql server check version
SQL
0 vote237 views1 answer
Create bdd mysql
SQL
1 vote223 views1 answer
Tsql random number
SQL
0 vote226 views1 answer
Oracle query archivemode
SQL
0 vote221 views1 answer
Change schema of all tables postgres
SQL
5 votes236 views4 answers
Mysql on duplicate key update
SQL
0 vote228 views1 answer
Product of a column in mysql
SQL

Share