The SQL Server instance I'm using is hosted by Microsoft Azure, and does not have the msforeachtable stored procedure. I had 50+ tables I needed to drop, and I wasn't interested in typing out the statement for each table. Instead, I used the following code to generate the DROP TABLE statements, and simply copied and pasted the result set into a new query window.

SELECT ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_TYPE = 'BASE TABLE'