SQL Server/T-SQL/System/sys.sql modules

Viewing UDF Metadata

6> SELECT name, type_desc, definition FROM sys.sql_modules s
7> INNER JOIN sys.objects o
8> ON s.object_id = o.object_id
9> WHERE TYPE IN ("IF", -- Inline Table UDF
10> "TF", -- Multistatement Table UDF
11> "FN") -- Scalar UDF
12> GO
name
         type_desc                                                    definition

------------------------------------------------------------------------------------------------------------------------
-------- ------------------------------------------------------------ --------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------