ms sql server 删除所有的视图、存储过程、函数

适用范围:sql2005以上

1.代码如下：

go
DECLARE Del_Cursor CURSOR
FOR
select * from
(
SELECT ('DROP PROCEDURE ' + name) as [Name] from dbo.sysobjects WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1
union all
SELECT ('DROP Function ' + name) as [Name] from dbo.sysobjects WHERE isnull(OBJECTPROPERTY(id, N'IsTableFunction'),-1)=1
union all
SELECT ('DROP Function ' + name) as [Name] from dbo.sysobjects WHERE isnull(OBJECTPROPERTY(id, N'IsScalarFunction'),-1)=1
union all
SELECT ('DROP view ' + name) as [Name] from sys.views WHERE [type]='V'
) [object]
OPEN Del_Cursor
DECLARE @curname sysname
FETCH NEXT FROM Del_Cursor into @curname
WHILE(@@fetch_status=0)
BEGIN
EXEC(@curname)
FETCH NEXT FROM Del_Cursor into @curname
END
CLOSE Del_Cursor
DEALLOCATE Del_Cursor
GO