/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 vote127 views1 answer
OFFSET consulta mysql
SQL
0 vote119 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote121 views1 answer
See the structure of a table mysql
SQL
3 votes190 views1 answer
Mysql group_concat distinct
SQL
0 vote125 views1 answer
T sql less than date
SQL
0 vote118 views2 answers
How to set global time_zone in mysql
SQL
12 votes130 views1 answer
How to change the value of a table in sql
SQL
0 vote148 views1 answer
Get created time of database psql 8
SQL
2 votes139 views1 answer
Sql get the name of user pc
SQL
1 vote128 views1 answer
Isnull sql server
SQL

Share