/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

1 vote203 views1 answer
Column with prefix in sql
SQL
0 vote212 views1 answer
Mysql query to add hours to column in table
SQL
0 vote228 views1 answer
Sql examples from framework
SQL
0 vote232 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
2 votes208 views1 answer
Sql alchemy or
SQL
2 votes260 views2 answers
Set value to null sql
SQL
0 vote232 views1 answer
Insert data from stored procedure into table
SQL
0 vote223 views1 answer
Why we have to set the password for my sql server
SQL
0 vote228 views1 answer
Oracle swap partition
SQL
-1 vote225 views1 answer
Round up and down sql
SQL

Share