<p>I am walking through the MS Press Windows Workflow Step-by-Step book and in chapter 8 it mentions a tool with the filename "wca.exe".  This is supposed to be able to generate workflow communication helper classes based on an interface you provide it.  I can't find that file.  I thought it would be in the latest .NET 3.5 SDK, but I just downloaded and fully installed, and it's not there.  Also, some MSDN forum posts had links posted that just go to 404s.  So, where can I find wca.exe?</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]%'
```
```