How to get all functions in a database

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:

Post a Comment

0 Comments