/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

16 votes150 views2 answers
Gremove folder from git
SQL
2 votes171 views1 answer
Mysql cannot delete or update a parent row
SQL
8 votes175 views2 answers
How to fetch data from database without last column
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
0 vote144 views1 answer
Sql date between one week
SQL
0 vote154 views1 answer
Google sheets filter rows above current cell
SQL
0 vote162 views1 answer
Provide hardcoded value in the mysql query
SQL
4 votes164 views4 answers
Check constraint in ms sql
SQL
0 vote189 views1 answer
Mysql where sum > 0
SQL
0 vote170 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL

Share