Mega Code Archive

 

Categories / MSSQL / System

 

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