/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

2 votes120 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote122 views1 answer
Exit psql
SQL
0 vote120 views1 answer
Where date major today mysql
SQL
-2 votes133 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote127 views1 answer
Sqlalchemy on delete set null
SQL
0 vote115 views1 answer
Sql server get date of previous sunday
SQL
1 vote115 views3 answers
Union in sql
SQL
-1 vote69 views2 answers
On delete set default sql server
SQL
49 votes203 views6 answers
Mysql add column to table
SQL
6 votes191 views1 answer
Sql insert values into table
SQL

Share