MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets
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