SQLProcedures uses the catalog stored procedure sp_stored_procedures to report the names of stored procedures in a Microsoft® SQL Server™ database.
The following table shows SQLProcedures parameter mapping for sp_stored_procedures stored procedure execution.
| SQLProcedures parameter name |
sp_stored_procedures parameter name |
|---|---|
| CatalogName | procedure_qualifier |
| SchemaName | procedure_owner |
| ProcName | procedure_name |
All SQL Server stored procedures return a value. SQLProcedures reports SQL_PT_FUNCTION for the result set column PROCEDURE_TYPE.
SQLProcedures returns SQL_SUCCESS whether or not values exist for CatalogName, SchemaName, or ProcName parameters. SQLFetch returns SQL_NO_DATA when invalid values are used in these parameters.
SQLProcedures can be executed on a static server cursor. An attempt to execute SQLProcedures on an updatable (dynamic or keyset) cursor will return SQL_SUCCESS_WITH_INFO indicating that the cursor type has been changed.
SQLProcedures returns information about any tables whose names match ProcName and are owned by the current user.