/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 vote214 views1 answer
Mysql login console
SQL
0 vote202 views1 answer
Sql get date from timestamp
SQL
9 votes201 views1 answer
Oracle get table schema
SQL
21 votes213 views1 answer
SQL cheat sheet pdf
SQL
-1 vote187 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote214 views1 answer
Create-table-with-index-organization
SQL
0 vote193 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote205 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote239 views2 answers
Sql unique
SQL
0 vote317 views1 answer
Sql change a colum to unique
SQL

Share