/SQL/Drop table with constraints

Drop table with 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 vote187 views1 answer
Tsql generate rows
SQL
9 votes203 views4 answers
Mysql show table fields
SQL
0 vote188 views1 answer
Postgresql get current user name
SQL
0 vote231 views1 answer
Oracle to_number
SQL
7 votes203 views1 answer
Connect mysql docker
SQL
2 votes210 views1 answer
Add new column not null sql server
SQL
0 vote197 views1 answer
Mysql trim characters
SQL
13 votes192 views6 answers
Mysql update from select
SQL
4 votes238 views5 answers
Get last query in codeigniter 4
SQL
0 vote189 views1 answer
Mysql Install Ubuntu with native password
SQL

Share