http://www.biinsight.com/how-to-drop-tables-database-wide-using-t-sql/
How to drop tables database wide using T-SQL