We can use sys.objects catalog view as shown in the below script to get all the functions in a database.
Example:
SELECT OB.Name, SM.[Definition], OB.type_desc
FROM sys.objects Ob
INNER JOIN sys.sql_modules SM
ON SM.object_id=OB.object_id
WHERE OB.type_desc like '%function%'
Result:
0 Comments