PROCEDURES Rowset

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.

1998-2001 Microsoft Corporation. All rights reserved.