/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 vote148 views1 answer
Disable database droping sql
SQL
9 votes188 views3 answers
Pyodbc connect to sql server
SQL
3 votes104 views2 answers
Coalesce mysql
SQL
1 vote159 views2 answers
End mysql command
SQL
0 vote139 views1 answer
Basic structure of sql expression having clause
SQL
8 votes138 views1 answer
Oracle search source code
SQL
6 votes129 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
2 votes188 views2 answers
Mysql date range
SQL
0 vote141 views1 answer
Postgresql if else endif
SQL
10 votes134 views5 answers
Create table mysql query
SQL

Share