MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets


 

PROCEDURES Rowset

The PROCEDURES rowset is an OLE DB extension. 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 DB_PT_UNKNOWN—It is not known whether there is a returned value.

DB_PT_PROCEDURE—Procedure; there is no returned value.

DB_PT_FUNCTION—Function; there is a returned value.

PROCEDURE_DEFINITION DBTYPE_WSTR Procedure definition.
DESCRIPTION DBTYPE_WSTR Human-readable description of the procedure.
DATE_CREATED DBTYPE_DATE Date when the procedure was created or NULL if the provider does not have this information.

1.x providers do not return this column.

DATE_MODIFIED DBTYPE_DATE Date when the procedure definition was last modified or NULL if the provider does not have this information.

1.x providers do not return this column.


Default Sort Order: PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME