DECLARE test_cursor CURSOR
FOR select id,name from invest..sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and name not like 'sys%'
DECLARE @name varchar(100)
declare @id int
DECLARE @SQLSTR varchar(4000)
OPEN test_cursor
FETCH NEXT FROM test_cursor INTO @id,@name
WHILE (@@fetch_status <> -1)
BEGIN
BEGIN
set @sqlstr='drop view '+@name
select @sqlstr
select 'go'
--select text from sysobjects o,syscomments c where o.id=c.id and xtype='V' and name not like 'sys%' and o.id=@id
execute SP_HELPTEXT @objname=@name
select 'GO'
--exec @sqlstr
END
FETCH NEXT FROM test_cursor INTO @id,@name
END
CLOSE test_cursor
DEALLOCATE test_cursor
GO
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12172/viewspace-887285/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12172/viewspace-887285/