Search a function

To populate all User-Defined functions in the current database we can use the query
SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF')
To search specific User-Defined function by name we can use
SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF') and name LIKE '%zero%'

No comments:

Post a Comment