Get List of all User Defined Functions

We can use sys.objects(system view) to get the information about user defined functions. Below query return the name of all user defined function along with type.
 
Query
 
SELECT name AS Function_Name, type_desc as Type_
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%';
GO
 
Example
 
 
Ebook Download
View all
Learn
View all