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 |