/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

0 vote345 views1 answer
Find number of entries sql
SQL
0 vote342 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote369 views1 answer
Mysql subdate
SQL
0 vote354 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote368 views1 answer
Postgres statistics
SQL
0 vote362 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote383 views1 answer
Mysqli last row
SQL
5 votes369 views1 answer
Minecraft java port number
SQL
3 votes399 views1 answer
Postgres select max value
SQL
0 vote358 views1 answer
Create table sql generator
SQL

Share