/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 vote177 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote149 views1 answer
Sql server express download
SQL
2 votes164 views1 answer
Use cases condition in sql query laravel
SQL
0 vote170 views2 answers
Php convert dbf to mysql
SQL
0 vote167 views1 answer
Datagrip execute procedure
SQL
7 votes159 views5 answers
Oracle alter table
SQL
12 votes158 views6 answers
Select distinct
SQL
40 votes228 views4 answers
PostgreSQL add column
SQL
0 vote157 views1 answer
Oracle sql date summer time
SQL
2 votes146 views1 answer
Drop table if exists in postgres
SQL

Share