SQL SERVER – Find All The User Defined Functions (UDF) – Part 2

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)

SQL Function, SQL Scripts
Previous Post
SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)
Next Post
SQL SERVER – Understanding Licensing Models

Related Posts

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:

    Reply
  • Manish Agrahari
    July 29, 2011 12:48 pm

    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.

    Reply
  • Manish Agrahari
    July 30, 2011 7:02 pm

    thanks a lot madhivanan….

    Reply
  • Hi Madhivanan,
    How to find function definition in sql server ( ex for SP we use sp_helptext ‘SPName’)

    Reply

Leave a Reply