/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 vote207 views1 answer
Sql order by number not ordered
SQL
10 votes212 views1 answer
User_dependencies
SQL
45 votes235 views5 answers
Grant all privileges mysql
SQL
0 vote208 views1 answer
Sp in sql server
SQL
1 vote205 views1 answer
PLS-00225 type
SQL
3 votes204 views3 answers
Create table in microsoft sql server
SQL
18 votes200 views2 answers
Sql inner join
SQL
0 vote203 views1 answer
Inner join distinct
SQL
0 vote211 views2 answers
Oracle select
SQL
1 vote223 views2 answers
Intersect sql
SQL

Share