/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

6 votes145 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote105 views1 answer
Flask_sqlalchemy install
SQL
0 vote148 views1 answer
Sum sqlserver
SQL
4 votes165 views3 answers
NOT NULL SQL
SQL
0 vote145 views1 answer
Update and keep original value sql
SQL
0 vote165 views1 answer
Get only structure database mysql
SQL
17 votes149 views3 answers
Postgresql version command
SQL
1 vote164 views1 answer
Oracle activate job
SQL
1 vote143 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote152 views1 answer
Mariadb alter table add column if not exists example
SQL

Share