SyntaxFix

[mysql] Drop multiple tables in one shot in MySQL 

SET foreign_key_checks = 0;
DROP TABLE IF EXISTS a,b,c;
SET foreign_key_checks = 1;

Then you do not have to worry about dropping them in the correct order, nor whether they actually exist.

N.B. this is for MySQL only (as in the question). Other databases likely have different methods for doing this.

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to multiple-tables

• Multiple left joins on multiple tables in one query • SELECT * FROM multiple tables. MySQL • How to perform Join between multiple tables in LINQ lambda • Select from one table matching criteria in another? • Drop multiple tables in one shot in MySQL • sql - insert into multiple tables in one query

Examples related to drop-table

• How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1 • Can't drop table: A foreign key constraint fails • DROP IF EXISTS VS DROP? • Drop multiple tables in one shot in MySQL • SQL DROP TABLE foreign key constraint