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
------------------------------------------------------------------------------------------------------------------------
-------- ------------------------------------------------------------ --------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------