/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

33 votes168 views2 answers
Postgres how to add field created at
SQL
0 vote161 views1 answer
Datagrip exec
SQL
23 votes168 views4 answers
Sql server substring
SQL
1 vote154 views10 answers
Stack overflow
SQL
0 vote155 views1 answer
What are the aggregate function in sql
SQL
3 votes163 views2 answers
Plsql print
SQL
0 vote171 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote170 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote170 views1 answer
Oracle sql procedure return value
SQL
0 vote163 views1 answer
How to access to mysql without root
SQL

Share