PROCEDURES Rowset
GUID: DBSCHEMA_PROCEDURES
Number of restriction columns: 4
Restriction columns: PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, PROCEDURE_TYPE
Default sort order: PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME
Description: The PROCEDURES rowset is an OLE DB extension. It identifies the procedures defined in the catalog that are owned by a given user.
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. |