SQL触发器批量删除数据库中的表

以下通过触发器批量删除数据库中的表，SQL2008已验证

DECLARE @Table NVARCHAR(300)
DECLARE @Count Int = 0  
DECLARE tmpCur CURSOR FOR  
SELECT name FROM sys.objects WHERE TYPE='U' AND name LIKE N'temp_cost%' order by name
OPEN tmpCur 
FETCH NEXT FROM tmpCur INTO @Table 
WHILE @@FETCH_STATUS= 0   
    BEGIN 
        DECLARE @sql VARCHAR(100) 
        SELECT @sql='drop table ['+@Table+']'
        EXEC(@sql)
        Print convert(varchar(100),@Count)+':'+@sql
        SET @Count=@COUNT + 1 
        FETCH NEXT FROM tmpCur INTO @Table 
    END 
CLOSE tmpCur
DEALLOCATE tmpCur