/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

6 votes245 views2 answers
Mysql concatenate two columns into one
SQL
0 vote234 views1 answer
Mysql export search results
SQL
2 votes230 views1 answer
Oracle kill session by sql_id
SQL
0 vote219 views1 answer
Systems sql
SQL
0 vote231 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote221 views2 answers
Sqlite
SQL
-2 votes226 views1 answer
Mysql see users and passwords
SQL
5 votes238 views4 answers
Rollback to in sql
SQL
0 vote252 views1 answer
MySQL - Enabling the Event Scheduler
SQL
2 votes219 views1 answer
Sql like variable
SQL

Share