/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

3 votes129 views1 answer
Oracle rollback
SQL
0 vote128 views1 answer
Psql attribute cannot login
SQL
0 vote123 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote124 views1 answer
Sql comand for removing data from table
SQL
16 votes132 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
24 votes132 views6 answers
Sql change table name
SQL
0 vote127 views1 answer
Create table Statement Syntax in SQL Server
SQL
1 vote116 views1 answer
Can not connect to mysql server
SQL
0 vote152 views1 answer
Postgres change the name of schema
SQL
2 votes153 views1 answer
Cannot return non-composite value from function that returns composite type
SQL

Share