Viewing UDF Metadata : sys.sql_modules « System « SQL Server / T-SQL

1. SQL Server / T-SQL
2. System
3. 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


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

 

Related examples in the same category