使用sys.SQL_Modules获取SQL Server数据库对象（存储过程，视图，函数）定义脚本

 

USE

 

tempdb;

go

CREATE

 

PROC prDummy

AS

BEGIN

 

  SELECT 1

END

 

go

CREATE

 

VIEW vwDummy

AS

 

  SELECT 1 ColA

go

 

 

 

CREATE

 

FUNCTION fnDummy()

RETURNS

 

INT

AS

BEGIN

 

  RETURN 1

END

go

 

 

SELECT

 

object_Name(object_ID),definition FROM sys.SQL_Modules

 

DROP

 

PROC prDummy

DROP

 

VIEW vwDummy

DROP

 

FUNCTION fnDummy