/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 vote194 views1 answer
Mysql max number not returning correct value
SQL
0 vote218 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote195 views2 answers
2nd max salary query in sql
SQL
0 vote193 views5 answers
Mode sql course
SQL
0 vote226 views1 answer
Time in sql server
SQL
1 vote263 views1 answer
Mysql sort by date column
SQL
6 votes178 views2 answers
Mysql version check cmd
SQL
0 vote189 views1 answer
Dump only data
SQL
0 vote236 views1 answer
Select true if exists on another table or false sqlserver
SQL
2 votes212 views1 answer
Query to find table size in oracle 12c
SQL

Share