| OLE DB Programmer's Reference |  |
| OLE DB Programmer's Reference | |
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. |