/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

8 votes257 views4 answers
Postgresql server restart
SQL
0 vote252 views1 answer
Plsql check for string in numeric
SQL
12 votes214 views5 answers
Sql primary key
SQL
0 vote195 views1 answer
Sql view index
SQL
-1 vote189 views1 answer
Sql getdate date only
SQL
0 vote163 views1 answer
Mysql collation for all languages
SQL
16 votes205 views3 answers
Tsql rename column name
SQL
0 vote208 views2 answers
How to generate a unique random number in mysql
SQL
1 vote207 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote289 views1 answer
<sql:datasource var="Snapsho"
SQL

Share