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.