>I think you're missing TABLE_TYPE = 'BASE TABLE' WHERE condition
>
>>
>>

>>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
>>

In Custom database?
But you are right, better be save.

I'm stuck right now. What could be the problem with Michele's SQL Server? He can't execute sp_ForEachTable SP, can't use sys.Tables or INFORMATION_SCHEMA.Tables Views.