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
 
 
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now