Supported OLE DB Schema Rowsets in OLE DB Scanner

Meta Data Services Programming

Meta Data Services Programming

Supported OLE DB Schema Rowsets in OLE DB Scanner

Thirty types of database schema information can be fetched from an OLE DB data source. The Database object name column in the following table shows the name of the database objects that can be fetched. The Supported column indicates whether the item is supported by OLE DB Scanner. If an item is not supported, there is no corresponding item in the Open Information Model (OIM) to capture it. For more information about property descriptions and OLE DB type information, see the OLE DB documentation.

Database object name Supported
ASSERTIONS Yes
CATALOGS Yes
CHARACTER_SETS No
CHECK_CONSTRAINTS Yes
COLLATIONS No
COLUMN_DOMAIN_USAGE Yes
COLUMN_PRIVILEGES No
COLUMNS Yes
CONSTRAINT_COLUMN_USAGE Yes
CONSTRAINT_TABLE_USAGE Yes
FOREIGN_KEYS Yes
INDEXES Yes
KEY_COLUMN_USAGE Yes
PRIMARY_KEYS Yes
PROCEDURE_COLUMNS Yes
PROCEDURE_PARAMETERS Yes
PROCEDURES Yes
PROVIDER_TYPES Yes
REFERENTIAL_CONSTRAINTS Yes
SCHEMATA Yes
SQL_LANGUAGES No
STATISTICS No
TABLE_CONSTRAINTS Yes
TABLE_PRIVILEGES No
TABLES Yes
TRANSLATIONS No
USAGE_PRIVILEGES No
VIEW_COLUMN_USAGE No
VIEW_TABLE_USAGE No
VIEWS Yes