/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 votes131 views1 answer
Compare date in sql
SQL
0 vote157 views1 answer
Add new column in sql with foreign key
SQL
0 vote135 views1 answer
Django mysqlclient connection string
SQL
4 votes150 views1 answer
Alter session set nls_date_format
SQL
59 votes306 views6 answers
Alter table sql
SQL
0 vote116 views1 answer
Insert thai language sql server
SQL
0 vote168 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote124 views1 answer
Min:sec datediff mssql
SQL
0 vote140 views4 answers
Change schema in sql server
SQL
0 vote130 views1 answer
Sql server select value large text
SQL

Share