/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 vote352 views1 answer
Find all tables where column name exists oracle
SQL
-1 vote399 views2 answers
Sql search all tables for attributes
SQL
0 vote382 views1 answer
Psql initialization
SQL
-1 vote382 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
2 votes381 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote372 views1 answer
How to query without duplicate rows in sql
SQL
3 votes370 views1 answer
How to find names includes in sql
SQL
4 votes334 views2 answers
How to count items with same name in sql
SQL
4 votes404 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote362 views1 answer
How to define a save method in ruby for sql databases
SQL

Share