PROCEDURES Rowset

The PROCEDURES rowset is an OLE DB extension, based on SQL 3. It identifies the procedures defined in the catalog that are owned by a given user.

The PROCEDURES rowset contains the following columns:

Column name Type indicator Description
PROCEDURE_CATALOG DBTYPE_WSTR Catalog name. NULL if the provider does not support catalogs.
PROCEDURE_SCHEMA DBTYPE_WSTR Unqualified schema name. NULL if the provider does not support schemas.
PROCEDURE_NAME DBTYPE_WSTR Procedure name.
PROCEDURE_TYPE DBTYPE_I2 Specifies values as:
  • DB_PT_UNKNOWN, which indicates that it is not known whether there is a return value.

  • DB_PT_PROCEDURE, which indicates a procedure. There is no returned value.

  • DB_PT_FUNCTION, which indicates a function. There is no returned value.
PROCEDURE_DEFINITION DBTYPE_WSTR Procedure definition.
DESCRIPTION DBTYPE_WSTR Human-readable description of the procedure.

Default Sort Order: PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME.