/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 vote314 views1 answer
Sql basic commands
SQL
1 vote269 views1 answer
Mysql get latest duplicate rows
SQL
-1 vote328 views5 answers
Left join sql
SQL
0 vote289 views1 answer
Sql filter rows with condition
SQL
10 votes248 views2 answers
Mysql select timestamp group by day
SQL
0 vote278 views2 answers
How to use aggregate functions in sql
SQL
8 votes279 views1 answer
Script to add datafile to tablespace
SQL
-1 vote289 views1 answer
Pl sql drop trigger
SQL
1 vote273 views1 answer
Does insert into overwrite sql
SQL
0 vote281 views1 answer
Oracle query to find schema you are working on
SQL

Share