MDSCHEMA_INPUT_DATASOURCES Rowset

 

Applies To: SQL Server 2016 Preview

Describes the data sources defined within the database.

The MDSCHEMA_INPUT_DATASOURCES rowset contains the following columns.

Column nameType indicatorLengthDescription
CATALOG_NAMEDBTYPE_WSTRThe name of the catalog to which this data source belongs.
SCHEMA_NAMEDBTYPE_WSTRNot supported.
DATASOURCE_NAMEDBTYPE_WSTRThe name of the data source object.
DATASOURCE_TYPEDBTYPE_WSTRThe type of the data source. Valid values include:

 Relational

 Olap
CREATED_ONDBTYPE_DBTIMESTAMPThe date that the data source was created.
LAST_SCHEMA_UPDATEDBTYPE_DBTIMESTAMPThe date and time that the data source was last modified.
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the action.
TIMEOUTDBTYPE_UI4The timeout of the data source.

This schema rowset is not sorted.

The MDSCHEMA_INPUT_DATASOURCES rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
DATASOURCE_NAMEDBTYPE_WSTROptional.
DATASOURCE_TYPEDBTYPE_WSTROptional.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show: