/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

2 votes119 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
3 votes116 views2 answers
Postgres inner join vs join
SQL
1 vote117 views1 answer
SQLite order random
SQL
4 votes110 views1 answer
Search column by name mysql
SQL
0 vote102 views1 answer
Mql5 list all available symbols
SQL
1 vote117 views1 answer
T-SQL Alter the column data type
SQL
1 vote123 views1 answer
Mysql Case sum
SQL
3 votes121 views1 answer
How to find names includes in sql
SQL
0 vote147 views1 answer
How to rename a database in tsql
SQL
0 vote74 views1 answer
Store query result in variable sql
SQL

Share