Drop multiple tables named with prefix

 

How to drop multiple tables named with prefix (or named with similar pattern).

Drop multiple tables named with prefix (or named with similar pattern).

 

Generate DELETE statement to delete all tables with prefix \’mng_\’:

 

This code will build a query like this – \’DROP TABLE database_name.mng_table1, database_name.mng_table2, …\’

Run the generated query:

Leave a Reply

Your email address will not be published. Required fields are marked *