<p>How can I drop all tables whose names begin with a given string? </p>

<p>I think this can be done with some dynamic SQL and the <code>INFORMATION_SCHEMA</code> tables.</p>

```
```
SELECT 'DROP TABLE "' + TABLE_NAME + '"' 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '[prefix]%'
```
```
This will generate a script.
Adding clause to check existence of table before deleting:
```
```
SELECT 'IF OBJECT_ID(''' +TABLE_NAME + ''') IS NOT NULL BEGIN DROP TABLE [' + TABLE_NAME + '] END;' 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '[prefix]%'
```
```