/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 vote104 views1 answer
Sql server select rows by distinct column
SQL
0 vote103 views2 answers
Mysql regexp match word
SQL
1 vote110 views2 answers
Sql server add time to date
SQL
4 votes105 views1 answer
Postgresql show current database
SQL
0 vote108 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
3 votes121 views2 answers
See mysql users ubuntu
SQL
2 votes117 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote107 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote138 views1 answer
How much space does sql server take per row
SQL
2 votes105 views2 answers
Spring import sql
SQL

Share