/SQL/Drop table with constraints

Drop table with 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 vote177 views1 answer
How to between in sql
SQL
0 vote209 views1 answer
Mysql root localhost run
SQL
2 votes231 views2 answers
Postgres change owner of schema
SQL
27 votes219 views3 answers
Mysql show tables in database
SQL
0 vote188 views1 answer
Mysql jdbc timezone
SQL
0 vote189 views1 answer
Php delete database
SQL
-1 vote211 views1 answer
Mysql change database charset and collation
SQL
1 vote177 views1 answer
Delete triger pl pg sql
SQL
0 vote201 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote194 views1 answer
Oracle array
SQL

Share