To list all user defined functions in MSSQL you can use the following snippet.
Sample MSSQL
SELECT name AS function_name, SCHEMA_NAME(schema_id) AS SCHEMA_NAME ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' ORDER BY name asc;
To list all user defined functions in MSSQL you can use the following snippet.
SELECT name AS function_name, SCHEMA_NAME(schema_id) AS SCHEMA_NAME ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' ORDER BY name asc;
To get a list of all functions in mssql you can use the following snippet.
SELECT name AS [name],SCHEMA_NAME(schema_id) AS [schema_name], type_desc AS [type] FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' ORDER BY name asc