/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

1 vote216 views1 answer
Does insert into overwrite sql
SQL
0 vote245 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
2 votes219 views1 answer
While loop sql
SQL
2 votes221 views2 answers
How to add not null constraint in sql
SQL
0 vote217 views1 answer
Start and stop mysql
SQL
0 vote223 views1 answer
Sql server express download
SQL
1 vote226 views1 answer
Oracle schema size
SQL
0 vote213 views1 answer
Oracle create table auto generated primary key
SQL
0 vote206 views1 answer
How to count with except in psql
SQL
6 votes217 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL

Share