/SQL/Drop table with constraints

Drop table with 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

4 votes331 views2 answers
Sql select except null
SQL
2 votes197 views2 answers
Created at and updated at in mysql
SQL
1 vote206 views1 answer
Convert varchar to int in sqlite
SQL
38 votes282 views6 answers
Ubuntu install mysql client
SQL
0 vote233 views1 answer
Mssql find deadlocks
SQL
0 vote194 views1 answer
Oracle archivelog usage
SQL
1 vote315 views1 answer
Python clean sql string
SQL
2 votes214 views1 answer
Oracle to_char number format percentage
SQL
11 votes170 views1 answer
Reset identity sql server
SQL
1 vote215 views1 answer
Show indices in mysql table
SQL

Share