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'