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
One thought on “How to get a list of all functions in mssql”
Leave a Reply
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to get a list of all functions in #mssql http://t.co/z6MxnAGXiw #sql #coding #dotnet