/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

2 votes254 views1 answer
How to make insert script from table in SQL server
SQL
0 vote246 views1 answer
Oracle last connection
SQL
6 votes278 views2 answers
Mysql concatenate two columns into one
SQL
0 vote255 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
11 votes263 views2 answers
Insert current date sql
SQL
1 vote251 views1 answer
Oracle apex run 404
SQL
1 vote253 views1 answer
Oracle activate job
SQL
0 vote306 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote255 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote247 views1 answer
Transalations from sql to Linq count and group by
SQL

Share