/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 vote193 views1 answer
Get the next column of a table in mysql
SQL
1 vote171 views1 answer
Oracle add proxy
SQL
0 vote182 views1 answer
Sql query tags
SQL
1 vote193 views1 answer
Add multiple row table pl sql
SQL
1 vote182 views1 answer
Regular expression in sql server
SQL
7 votes189 views3 answers
Sql server reset auto increment
SQL
0 vote214 views1 answer
Capabilities of sql select statements
SQL
0 vote161 views1 answer
Oracle execute immediate quotes
SQL
1 vote171 views1 answer
Postgres convert exisiting column to text
SQL
1 vote155 views1 answer
Adding a default constraint to an existing column in sql
SQL

Share