/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 vote162 views2 answers
Temp Space
SQL
0 vote147 views1 answer
Sql server get date of previous sunday
SQL
0 vote178 views1 answer
Sql query inline if
SQL
0 vote150 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote229 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote281 views1 answer
Android sqlite add column if not exists
SQL
0 vote144 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote167 views1 answer
Postgresql round double precision
SQL
0 vote170 views1 answer
Play framework connection via windows sql server
SQL
0 vote178 views1 answer
Check if mysql db is used
SQL

Share