/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 vote184 views1 answer
Inserted row count tsql
SQL
2 votes185 views1 answer
Apex date today add days
SQL
0 vote204 views3 answers
Postgres date difference seconds
SQL
0 vote198 views1 answer
Postgresql find biggest table
SQL
0 vote181 views1 answer
Oracle DROP PROGRAM
SQL
4 votes180 views2 answers
Mysql select where starts with
SQL
1 vote193 views1 answer
Sysdate in sql
SQL
5 votes178 views1 answer
Ignore duplicate rows in sqlite
SQL
14 votes202 views1 answer
Oracle alter table add column not null
SQL
23 votes175 views4 answers
Sql server substring
SQL

Share