Sql Server Programming :: Listing all Functions in a Database


	Listing all Functions in a Database I know that the following query will list all stored procedures in a database select * from sys.procedures However, Do I list all (scalar-valued) functions in a database? Thanks in advance for any help. Cheers, Frank J. Reashore, MCSD.net, MCDBA SELECT * FROM sys.objects WHERE type_desc = 'SQL_SCALAR_FUNCTION'; "Frank J. Reashore" <f@HipDigital.com> wrote in message news:eGu4VbkPHHA.4364@TK2MSFTNGP03.phx.gbl... - Hide quoted text - >I know that the following query will list all stored procedures in a >database > select * from sys.procedures > However, Do I list all (scalar-valued) functions in a database? > Thanks in advance for any help. > Cheers, > Frank J. Reashore, MCSD.net, MCDBA Frank J. Reashore wrote: > I know that the following query will list all stored procedures in a > database > select * from sys.procedures > However, Do I list all (scalar-valued) functions in a database? > Thanks in advance for any help. > Cheers, > Frank J. Reashore, MCSD.net, MCDBA or SELECT [name] FROM sys.sysobjects WHERE xtype = 'FN' --Scalar SELECT [name] FROM sys.sysobjects WHERE xtype = 'TF' --Table SELECT [name] FROM sys.sysobjects WHERE xtype = 'IF' --In-lined table