How to get a list of all functions in mssql

To get a list of all functions in mssql you can use the following snippet.

Sample MSSQL

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

Please Share us:
Please rate this snippet

One thought on “How to get a list of all functions in mssql

Leave a Reply