/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

58 votes547 views4 answers
Mysql drop column
SQL
0 vote186 views1 answer
Define a variable in mysql from select
SQL
2 votes174 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote186 views4 answers
Forenkey code alchemy sql
SQL
2 votes167 views1 answer
Wait delay in sql server
SQL
0 vote163 views1 answer
Call procedure in wordpress
SQL
0 vote289 views1 answer
Sql insert exemplo
SQL
5 votes229 views1 answer
How to get all table names in sql query
SQL
0 vote131 views1 answer
Calculate discount from original price sql
SQL
0 vote154 views1 answer
Get who is hired in month in sql
SQL

Share