/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 vote221 views1 answer
Oracle drop default value
SQL
0 vote249 views1 answer
Sql update subtract value
SQL
1 vote193 views1 answer
Restart identity postgresql
SQL
0 vote255 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote253 views1 answer
Mysql cli output to a file
SQL
0 vote236 views1 answer
Sql recherche nom prenom
SQL
2 votes252 views1 answer
Oracle sql merge
SQL
3 votes246 views2 answers
Install mysql powershell
SQL
0 vote251 views1 answer
What does leave do in mysql
SQL
3 votes267 views1 answer
Laravel paginate raw sql
SQL

Share