Labels

Monday, January 28, 2013

SQL Query to display all User Defined Functions


SELECT name AS function_name
,SCHEMA_NAME(schema_id) AS schema_name
,type_desc
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%'

No comments:

Post a Comment