delete tables with prefix

[IDTstudios1]

How can i delete all of the table in a db with a certain prefix(ex. blah_)?

thanks

 

[DRJ478]

Can you tell us what database server you are talking about?
For MySQL:
The DROP TABLE syntax does not support wildcards, and I think that is good so - no dropped tables because of a typo.
I would suggest that you follow these steps:
1. List all table names that match the pattern

http://dev.mysql.com/doc/mysql/en/show-tables.html

2. Concatenate those names with commas and fill it into the SQL statement "DROP TABLES".

This is the safe way to do what you want to achieve.

 

[IDTstudios1]

Sorry, I often to forget to specify wich db. I guess since i only work with mysql i forget there are others.

thanks for the help