>USE YourDataBase >DECLARE @TableName AS varchar(8000) >DECLARE @sql AS varchar(8000) >SELECT @TableName = MIN(Table_Name) FROM INFORMATION_SCHEMA.Tables >WHILE @TableName IS NOT NULL > BEGIN > SET @sql = 'DROP TABLE '+@TableName > EXEC (@sql) > SELECT @TableName = MIN(Table_Name) FROM INFORMATION_SCHEMA.Tables WHERE Table_Name > @TableName > END >I see you already have some code for that. :)