OLE DB Schema Rowsets

OLE DB Schema Rowsets

 

Applies To: SQL Server 2016 Preview

The following OLE DB schema rowsets are supported by the Microsoft XML for Analysis (XMLA) provider. Use the DISCOVER_ENUMERATORS rowset with the Discover method to check whether a particular data source provider supports a rowset.

You can also find detailed information about these rowsets by searching for the topic "Schema Rowsets" in the OLE DB Programmer's Reference portion of the MSDN® Library at the Microsoft Web site.

The following table describes this schema rowset.

RowsetDescription
DBSCHEMA_ASSERTIONSIdentifies the assertions that are defined in the catalog and owned by a given user.
DBSCHEMA_CATALOGS Rowset 1Identifies the physical attributes associated with catalogs that are accessible from the database management system (DBMS). For some systems, such as Microsoft Access, there may be only one catalog. For SQL Server, this rowset enumerates all catalogs (databases) defined in the system database.
DBSCHEMA_CHARACTER_SETSIdentifies the character sets that are defined in the catalog and accessible to a given user.
DBSCHEMA_CHECK_CONSTRAINTSIdentifies the check constraints that are defined in the catalog and owned by a given user.
DBSCHEMA_CHECK_CONSTRAINTS_BY_TABLEIdentifies the check constraints for a given table, defined in a catalog owned by a given user.
DBSCHEMA_COLLATIONSIdentifies the character collations that are defined in the catalog and accessible to a given user.
DBSCHEMA_COLUMN_DOMAIN_USAGEIdentifies the columns defined in the catalog that are dependent on a domain defined in the catalog and owned by a given user.
DBSCHEMA_COLUMN_PRIVILEGESIdentifies the privileges on columns of tables that are defined in the catalog and are available to or granted by a given user.
DBSCHEMA_COLUMNS Rowset 1Provides column information for all columns meeting the provided restriction criteria.
DBSCHEMA_CONSTRAINT_COLUMN_USAGEIdentifies the columns used by referential constraints, unique constraints, check constraints, and assertions and that are defined in the catalog and owned by a given user.
DBSCHEMA_CONSTRAINT_TABLE_USAGEIdentifies the tables that are used by referential constraints, unique constraints, check constraints, and assertions and that are defined in the catalog and owned by a given user.
DBSCHEMA_FOREIGN_KEYSIdentifies the foreign key columns defined in the catalog by a given user. This schema rowset is built upon several ISO schema views as a convenience to the non-SQL programmer. If supported, this schema rowset must be synchronized with the related ISO views (REFERENTIAL_CONSTRAINTS and CONSTRAINT_COLUMN_USAGE).
DBSCHEMA_INDEXESIdentifies the indexes that are defined in the catalog and owned by a given user.
DBSCHEMA_KEY_COLUMN_USAGEIdentifies the columns that are defined in the catalog and are constrained as keys by a given user.
DBSCHEMA_PRIMARY_KEYSIdentifies the primary key columns defined in the catalog by a given user. This schema rowset is built upon an ISO schema view as a convenience to the non-SQL programmer. If supported, this schema rowset must be synchronized with the related ISO view (CONSTRAINT_COLUMN_USAGE).
DBSCHEMA_PROCEDURE_COLUMNSReturns information about the columns of rowsets returned by procedures.
DBSCHEMA_PROCEDURE_PARAMETERSReturns information about the parameters and return codes of procedures.
DBSCHEMA_PROCEDURESIdentifies the procedures that are defined in the catalog and owned by a given user. This is an OLE DB extension.
DBSCHEMA_PROVIDER_TYPES Rowset 1Identifies the (base) data types supported by the data provider.
DBSCHEMA_REFERENTIAL_CONSTRAINTSIdentifies the referential constraints that are defined in the catalog and owned by a given user.
DBSCHEMA_SCHEMATAIdentifies the schemas that are owned by a given user.
DBSCHEMA_SQL_LANGUAGESIdentifies the conformance levels, options, and dialects supported by the SQL implementation processing data defined in the catalog.
DBSCHEMA_STATISTICSIdentifies the statistics that are defined in the catalog and owned by a given user.

This table is not related to the TABLE_STATISTICS rowset.
DBSCHEMA_TABLE_CONSTRAINTSIdentifies the table constraints that are defined in the catalog and owned by a given user.
DBSCHEMA_TABLE_PRIVILEGESIdentifies the privileges on tables that are defined in the catalog and available to or granted by a given user.
DBSCHEMA_TABLE_STATISTICSDescribes the available set of statistics on tables in the provider.

This rowset is not related to the STATISTICS rowset.
DBSCHEMA_TABLES Rowset 1Identifies the measure groups and dimensions exposed as tables within SQL Server Analysis Services.
DBSCHEMA_TABLES_INFO 1Identifies the tables (including views) that are defined in the catalog and accessible to a given user.
DBSCHEMA_TRANSLATIONSIdentifies the character translations that are defined in the catalog and accessible to a given user.
DBSCHEMA_TRUSTEEEnumerates the trustees for a data source.
DBSCHEMA_USAGE_PRIVILEGESIdentifies the USAGE privileges on objects that are defined in the catalog and are available to or granted by a given user.
DBSCHEMA_VIEW_COLUMN_USAGEIdentifies the views that are defined in the catalog and accessible to a given user.
DBSCHEMA_VIEW_TABLE_USAGEIdentifies the tables on which viewed tables, defined in the catalog and owned by a given user, are dependent.
DBSCHEMA_VIEWSIdentifies the views that are defined in the catalog and accessible to a given user.

1 Indicates schema rowsets supported by the MSOLAP data source provider for the Microsoft XMLA provider.

DISCOVER_ENUMERATORS Rowset
Analysis Services Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft