/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 vote183 views1 answer
Postgresql get diff between two dates in Months
SQL
20 votes222 views4 answers
How to find average in sql
SQL
0 vote188 views1 answer
Psql check if sql script is valid
SQL
92 votes2.3K views6 answers
Substring
SQL
3 votes230 views2 answers
Wp do sql query from function
SQL
0 vote177 views1 answer
Oarcale list objects
SQL
0 vote186 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote146 views2 answers
Sql update from two different database
SQL
0 vote180 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
3 votes203 views1 answer
Oracle user quota on tablespace
SQL

Share