/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

3 votes181 views2 answers
Plsql print
SQL
0 vote189 views1 answer
How to use query in nosql
SQL
0 vote171 views1 answer
Sort by last two number sql
SQL
0 vote190 views1 answer
Set a default value for a column in sqlite
SQL
0 vote169 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote191 views1 answer
Date on SQL
SQL
0 vote196 views2 answers
Update query with between in mysql
SQL
10 votes194 views1 answer
Oracle dependencies table
SQL
2 votes199 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote203 views1 answer
Mysql where in keep order
SQL

Share