Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database.
USE AdventureWorks
GO
SELECT specific_name,specific_schema
FROM information_schema.routines
WHERE routine_type='function'
GO
Reference : Pinal Dave (https://blog.sqlauthority.com)
5 Comments. Leave new
This is another way to do the same thing:
SELECT *
FROM sys.objects
WHERE type_desc = ‘SQL_SCALAR_FUNCTION’
Please refer to:
Hi all,
I need a query which give name of all stored procedure and view which are using a specific function.
For Example:- i have a User defined function in my database named “usp_split”.
I want to get list of all Stored Procedure and View which are using this function.
Thanks in advance.
EXEC sp_depends ‘usp_split’
thanks a lot madhivanan….
Hi Madhivanan,
How to find function definition in sql server ( ex for SP we use sp_helptext ‘SPName’)