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