Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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...

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
Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc