/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 vote136 views1 answer
SELECT statement to find the specific cell in database table
SQL
2 votes137 views3 answers
Postgres json to string
SQL
1 vote108 views1 answer
Sql server 2012 query history
SQL
1 vote111 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote125 views2 answers
Get item by composite primary key mysql
SQL
0 vote119 views1 answer
Mysql date time string format for marshmellow field schema
SQL
7 votes122 views1 answer
Sql pagination oracle
SQL
2 votes113 views1 answer
Mysql select random id from table
SQL
0 vote100 views1 answer
SQL division of an integer by another integer get float CAST
SQL
23 votes136 views4 answers
Uninstall postgresql ubuntu
SQL

Share