/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

23 votes121 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote133 views1 answer
Sauvegarde complète my sql
SQL
0 vote140 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote133 views2 answers
Start mysql server using docker
SQL
0 vote130 views2 answers
Update information in a mysql column
SQL
0 vote160 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
4 votes137 views1 answer
Oracle select first 10 rows
SQL
2 votes132 views1 answer
Plsql block
SQL
0 vote133 views1 answer
Mysql user set plugin
SQL
8 votes150 views1 answer
Oracle add datafile to tablespace
SQL

Share