SQLProcedures

ODBC and SQL Server

ODBC and SQL Server

SQLProcedures

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.

See Also

sp_stored_procedures