/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

6 votes220 views2 answers
How to get yesterday date in mysql
SQL
0 vote291 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote223 views1 answer
How to input data as id in database sql c#
SQL
0 vote189 views1 answer
SQLServerException.makeFromDatabaseError
SQL
19 votes176 views6 answers
What is mySQL
SQL
8 votes187 views1 answer
Check mysql version phpmyadmin
SQL
8 votes150 views1 answer
Oracle current date plus 1 month
SQL
3 votes193 views2 answers
How to delete git repo locally
SQL
0 vote184 views2 answers
Sql server select first day of previous year
SQL
3 votes170 views4 answers
Show sql server database
SQL

Share