How to Get Definition for Stored Procedures, UDFs and Triggers using T-SQL

If you want to list the definition for a stored procedure, User Defined Function, or Trigger, you can use one of the following ways:

-- using sp_helptext
sp_helptext 'dbo.your_object_name'

-- using syscomments
SELECT  
FROM sys.syscomments
WHERE OBJECT_NAME(id) = 'your_object_name'

-- using built in function OBJECT_DEFINITION
SELECT OBJECT_DEFINITION(OBJECT_ID('your_object_name'))

Rating: 8.9/10 (18 votes cast)

Rating: 0 (from 0 votes)

How to Get Definition for Stored Procedures, UDFs and Triggers using T-SQL, 8.9 out of 10 based on 18 ratings

Be Sociable, Share!

belle’s sql musings