/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 vote298 views1 answer
Mysql persistence.xml
SQL
0 vote258 views1 answer
Sql truncate table referencing itself
SQL
0 vote322 views1 answer
Postgres list users and roles
SQL
0 vote295 views1 answer
Import excel to sql
SQL
0 vote310 views1 answer
How to generate ids in sql
SQL
0 vote278 views1 answer
Sql query for getting data with join and count
SQL
3 votes296 views2 answers
Brew restart mysql
SQL
27 votes292 views4 answers
Get all tables with column name sql
SQL
1 vote270 views1 answer
Autocommit mysql
SQL
0 vote306 views1 answer
Sql developer search all packages for text
SQL

Share