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