Отображение определения определяемых пользователем функций Transact-SQL

SQL

SELECT definition, type

FROM sys.sql_modules AS m

JOIN sys.objects AS o ON m.object_id = o.object_id

AND type IN ('FN', 'IF', 'TF');

GO