Share via


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.