/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

0 vote231 views1 answer
Character count sql
SQL
0 vote214 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote205 views1 answer
Create synonym for dblink in oracle
SQL
9 votes201 views4 answers
How to create new user and database postgresql in ubuntu
SQL
25 votes249 views5 answers
Mysql replace text
SQL
0 vote195 views1 answer
Sql view index
SQL
2 votes198 views1 answer
Get first 2 letter in sql
SQL
1 vote279 views1 answer
Postgresql float 2 decimal places
SQL
0 vote201 views2 answers
Sql join on wildcard
SQL
1 vote216 views1 answer
Sql server kill all connections
SQL

Share