Delete multiple tables in one shot in mysql

Question

How to delete several tables from one database with one command. something like

> use test; > drop table a,b,c; 

where a, b, c are the tables from the database test.

Answer 1

Example:

Let's say table A has two children B and C. Then we can use the following syntax to delete all tables.

 DROP TABLE IF EXISTS B,C,A; 

This can be placed at the top of the script instead of individually deleting each table.

Answer 2

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

Then you do not need to worry about dropping them in the correct order and not really exist.

Answer 3

 declare @sql1 nvarchar(max) SELECT @sql1 = STUFF( ( select ' drop table dbo.[' + name + ']' FROM sys.sysobjects AS sobjects WHERE (xtype = 'U') AND (name LIKE 'GROUP_BASE_NEW_WORK_%') for xml path('') ), 1, 1, '') execute sp_executesql @sql1