sp_stored_procedures

Description

Returns a list of available procedures.

Syntax

sp_stored_procedures [sp_name] [, sp_owner]
 [, sp_qualifier]

Parameters

sp_name: is the stored procedure name. Use the wildcard character to request information about more than one stored procedure.

sp_owner: is the owner of the stored procedure. Use the wildcard character to request information about procedures owned by more than one user.

sp_qualifier: is the name of the database. Acceptable values are the current database or NULL.

Usage

This procedure corresponds to the ODBC function SQLProcedures.