listing UDF's

Does anyone know of a way to list out all the UDF's in database in a way
similar to what sp_tables, or sp_databases does?
AHIhelp
AHIhelp wrote:
> Does anyone know of a way to list out all the UDF's in database in a
> way similar to what sp_tables, or sp_databases does?
select * from sysobjects where type in ('FN', 'IF', 'TF')
-- OR
Select * from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'FUNCTION'
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||THANKS - that works great
AHIhelp
"David Gugick" wrote:

> AHIhelp wrote:
> select * from sysobjects where type in ('FN', 'IF', 'TF')
> -- OR
> Select * from INFORMATION_SCHEMA.ROUTINES
> where ROUTINE_TYPE = 'FUNCTION'
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>