/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 vote147 views1 answer
Turn on foreign keys check mysql
SQL
0 vote152 views1 answer
Oracle exchange subpartition
SQL
0 vote152 views1 answer
Get last date join sql
SQL
0 vote145 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote140 views1 answer
Sqlite closes value
SQL
0 vote150 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
4 votes185 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote146 views1 answer
Dbms_output sql developer
SQL
19 votes154 views3 answers
How to change column type psql
SQL
2 votes145 views1 answer
Mysql sql add created updated timestamp to existing table
SQL

Share