/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 vote262 views1 answer
Mysql 1 hour ago
SQL
0 vote289 views1 answer
Select new table sql
SQL
0 vote275 views1 answer
How to print some string in mysql
SQL
2 votes262 views1 answer
Compare date in sql
SQL
0 vote264 views1 answer
Mysql get only the field names in a table
SQL
0 vote328 views1 answer
Delete ids between sql
SQL
0 vote249 views1 answer
Cannot start database server xampp mac os
SQL
0 vote256 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
5 votes260 views2 answers
Oracle list columns schema
SQL
0 vote267 views1 answer
Sql query tags
SQL

Share