SQL SERVER 游标删除无数据试图

Declare @SQLToken varchar(max)
set @SQLToken  = ''
declare hCForEachTable cursor global for 
select '[' + REPLACE(schema_name(syso.schema_id), N']', N']]') + ']' + '.' + '[' + REPLACE(object_name(o.id), N']', N']]') + ']' 
from dbo.sysobjects o

join sys.all_objects syso 
    on o.id = syso.object_id

where OBJECTPROPERTY(o.id, N'IsVIEW') = 1 and o.category & 2 = 0 

OPEN hCForEachTable;
Declare @tablename varchar(max)
Declare @Temp varchar(max)
FETCH NEXT FROM hCForEachTable;
WHILE @@FETCH_STATUS = 0
BEGIN
    FETCH NEXT FROM hCForEachTable into @tablename;
    set @Temp  = 'if not exists(select 1 from '+@tablename+') drop view '+@tablename + ';'
    set @SQLToken= @SQLToken + @Temp
    set @Temp = ''
    set @tablename = ''
END;
SELECT @SQLToken
CLOSE hCForEachTable;
DEALLOCATE hCForEachTable;

来自为知笔记(Wiz)