/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 vote262 views1 answer
Mysql sum per week
SQL
0 vote210 views1 answer
Sql ignore
SQL
0 vote242 views1 answer
Postgresql import data from csv
SQL
0 vote247 views1 answer
Table user postgres
SQL
1 vote193 views1 answer
Mysql count words
SQL
0 vote187 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote180 views1 answer
Error code 1241 mysql
SQL
0 vote212 views2 answers
Sql stored procedure for access frontend
SQL
0 vote199 views1 answer
Sql server datetime to string
SQL
0 vote284 views1 answer
Shortcut run sql pgadmin
SQL

Share