CREATE TABLE #TEMP(TBLNAME VARCHAR(200))
SELECT 'IF (SELECT COUNT(*) FROM '+TABLE_SCHEMA+'.'+TABLE_NAME +')=0 INSERT INTO #TEMP SELECT '''+TABLE_SCHEMA+'.'+TABLE_NAME +''' '
from INFORMATION_SCHEMA.TABLES order by TABLE_SCHEMA,TABLE_NAME
SELECT 'DROP TABLE '+TABLENAME FROM #TEMP
