/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 vote160 views1 answer
Mysql pv progres
SQL
0 vote148 views1 answer
Search db for table name
SQL
0 vote161 views1 answer
How to convert external table to managed table in hive
SQL
0 vote158 views1 answer
Query string starts with vowels
SQL
0 vote167 views1 answer
Sql remove non numeric characters
SQL
0 vote118 views1 answer
Copy data from cell to cell mysql
SQL
17 votes161 views5 answers
Order by sql
SQL
0 vote145 views1 answer
Mysqldump ignore table
SQL
0 vote134 views1 answer
Select value from previous row in postgresql
SQL
0 vote157 views1 answer
Sql values not in another table
SQL

Share