Query to Find the List of Functions in SQL Server 2005-SQL Server 2008

Here is a  SQL Query to find the list of Functions in SQL Server database.When you run this query it will show the list of all functions in SQL Server DataBase.

SELECT name FROM sys.objects
WHERE type IN ('AF ','FN', 'IF', 'TF', 'FS', 'FT')

Tags: , ,

Join Us!