/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 vote358 views1 answer
Order by with where clause in mysql
SQL
0 vote363 views2 answers
Add colum in sql
SQL
0 vote342 views1 answer
Many rows to 1 string mysql
SQL
0 vote359 views1 answer
How to reset the database value in SQL server
SQL
0 vote356 views1 answer
Sql delete from with relation
SQL
0 vote341 views3 answers
Group_concat sql server
SQL
0 vote340 views1 answer
Sql anywhere create procedure
SQL
0 vote365 views1 answer
Intellij idea add mysql connector
SQL
0 vote349 views1 answer
Postgresql heritage
SQL
0 vote354 views1 answer
TSQL convert csv to table
SQL

Share