/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

3 votes314 views4 answers
Order by desc postgres
SQL
0 vote324 views1 answer
Oracle exchange subpartition
SQL
0 vote250 views1 answer
Check id exist or not in sql
SQL
20 votes353 views4 answers
How to find average in sql
SQL
0 vote256 views1 answer
Mysql offset from bottom
SQL
0 vote304 views1 answer
Oracle procedure teamplate
SQL
-1 vote307 views1 answer
How to switch user in mysql
SQL
0 vote296 views1 answer
How to change the field size of an existing column
SQL
0 vote297 views1 answer
Find largest table in mysql database
SQL
0 vote285 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL

Share