/SQL/Drop table with constraints

Drop table with 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 vote191 views1 answer
Select in select sql
SQL
10 votes256 views4 answers
Mysql one week ago
SQL
0 vote195 views1 answer
Kill a pid redshift
SQL
0 vote188 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
33 votes197 views6 answers
Sql delete
SQL
1 vote190 views1 answer
Restart identity postgresql
SQL
0 vote193 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote195 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
-1 vote225 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
3 votes291 views1 answer
How to get yesterday date in sql
SQL

Share