/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

2 votes273 views1 answer
Sql ignore accents
SQL
0 vote258 views1 answer
Mysql earlier than date
SQL
0 vote287 views1 answer
Postgresql function ROUND
SQL
11 votes346 views2 answers
Import mysql dump command line windows
SQL
0 vote314 views1 answer
Mysql change default collation
SQL
1 vote288 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
4 votes266 views1 answer
Wilayah indonesia database
SQL
11 votes259 views1 answer
Reset identity sql server
SQL
0 vote295 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote306 views1 answer
Gcloud sql instance list
SQL

Share