/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

9 votes373 views5 answers
Laravel to sql
SQL
0 vote369 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote351 views1 answer
How to use query in nosql
SQL
8 votes356 views1 answer
Oracle search source code
SQL
1 vote363 views1 answer
Convert varchar to int in sqlite
SQL
0 vote356 views1 answer
Sql server union if table exist
SQL
0 vote373 views1 answer
Find usage of table in sql server
SQL
0 vote371 views1 answer
Create a table from one field of another table
SQL
0 vote386 views1 answer
Providername system.data. mysql
SQL
0 vote364 views1 answer
How to add timestamp column in mysql
SQL

Share