SQL list of all the user defined functions in a database

sql-server, sql-server-2008-r2

Solution

SELECT o.name, m.definition, o.type_desc 
  FROM sys.sql_modules m 
INNER JOIN sys.objects o 
        ON m.object_id=o.object_id
WHERE o.type_desc like '%function%'

Problem

I am looking for a SQL query that outputs the function definitions for all of the user defined functions in a database catalog. I have found as far as ``` SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.UserFunctionName')) AS [Object Definition] ``` and ``` SELECT ROUTINE_NAME FROM information_schema.routines WHERE routine_type = 'function' ``` but I can't think of or find a way to feed the ROUTINE_NAME list to the OBJECT_ID. The purpose here is a searchable text of the user defined function definitions in a database for database change analysis, if something like a full SQL procedure or purposed helper program is easier, I will do that and post it.

Original source

Related problems