/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

2 votes108 views1 answer
Q operator in oracle
SQL
0 vote101 views1 answer
Sql server inner join convert collation
SQL
0 vote88 views1 answer
Postgresql conectar
SQL
1 vote105 views2 answers
Rebuild index sql server
SQL
46 votes171 views4 answers
Create column sql
SQL
0 vote160 views1 answer
How to get all values in a table mysql in c#
SQL
6 votes110 views1 answer
To count number of rows in SQL table
SQL
0 vote87 views1 answer
Mariadb set vertical output format
SQL
0 vote142 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote101 views1 answer
Check if table exists oracle
SQL

Share