/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

0 vote319 views1 answer
Oracle query archivemode
SQL
6 votes342 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote340 views2 answers
Sql insert timestamp
SQL
8 votes350 views2 answers
Between operator
SQL
14 votes356 views4 answers
Sql compiler
SQL
3 votes313 views2 answers
Brew start mysql
SQL
8 votes290 views3 answers
Duplicate entry
SQL
2 votes392 views2 answers
Python escape string for sql
SQL
9 votes327 views6 answers
Check constraint in sql
SQL
1 vote311 views2 answers
Mysql trim whitespace
SQL

Share