/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

2 votes284 views2 answers
Mysql alter column default
SQL
17 votes288 views6 answers
What is cursor in sql server with example
SQL
7 votes265 views1 answer
Forge server hosting
SQL
2 votes223 views1 answer
Sql group by different columns
SQL
36 votes284 views3 answers
Finding duplicate column values in table with sql
SQL
3 votes292 views1 answer
Postgresql today - 1 year
SQL
2 votes302 views1 answer
Mysql create user with remote access
SQL
0 vote364 views1 answer
Mysql show schema
SQL
0 vote298 views1 answer
Querry mysql by 2 columns
SQL
0 vote267 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL

Share