How to see content/description of a function in SQL Server

Question

http://idownvotedbecau.se/noresearch/ Don't post and then answer your own question when the answer you provide is an exact dupe of an existing SO post. — dfundako, Aug 09 '18 at 13:53

score 0 · Accepted Answer · edited Aug 09 '18 at 13:31

0

sp_helptext N'objectName'

objectName can be a stored procedure or a function name

edited Aug 09 '18 at 13:31

Yogesh Sharma

49,870
5
26
52

answered Aug 09 '18 at 13:25

Ali Karaca

3,365
1
35
41

Rahul · Answer 2 · 2018-08-09T13:32:58.603

0

You can use sp_helptext like

sp_helptext procedure_name

edited Aug 09 '18 at 13:32

answered Aug 09 '18 at 13:27

Rahul

76,197
13
71
125

score 0 · Answer 3 · answered Aug 09 '18 at 13:30

below is an example you can follow this

USE AdventureWorks2012;  
    GO  
    -- Get the function name, definition, and relevant properties  
    SELECT sm.object_id,   
       OBJECT_NAME(sm.object_id) AS object_name,   
       o.type,   
       o.type_desc,   
       sm.definition,  
       sm.uses_ansi_nulls,  
       sm.uses_quoted_identifier,  
       sm.is_schema_bound,  
       sm.execute_as_principal_id  
    -- using the two system tables sys.sql_modules and sys.objects  
    FROM sys.sql_modules AS sm  
    JOIN sys.objects AS o ON sm.object_id = o.object_id  
    -- from the function 'dbo.ufnGetProductDealerPrice'  
    WHERE sm.object_id = OBJECT_ID('dbo.ufnGetProductDealerPrice')  
    ORDER BY o.type;  
    GO

https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/view-user-defined-functions?view=sql-server-2017

How to see content/description of a function in SQL Server

3 Answers3