/SQL/DROP TABLes regardless of constraints

DROP TABLes regardless of 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 vote313 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote310 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote308 views1 answer
Get cpu details sql
SQL
0 vote306 views1 answer
Sql beginning of previous month
SQL
0 vote270 views1 answer
Jooq finding lastest value in table
SQL
6 votes322 views2 answers
Mysql interval 1 day
SQL
1 vote307 views1 answer
Psql datetime grather than
SQL
7 votes310 views6 answers
Group_concat mysql
SQL
0 vote303 views1 answer
Sql grant select only
SQL
0 vote364 views1 answer
Kimball data warehouse sql calendar
SQL

Share