Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

MDSCHEMA_INPUT_DATASOURCES Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Describes the data sources defined within the database.

The MDSCHEMA_INPUT_DATASOURCES rowset contains the following columns.

Column name

Type indicator

Length

Description

CATALOG_NAME

DBTYPE_WSTR

The name of the catalog to which this data source belongs.

SCHEMA_NAME

DBTYPE_WSTR

Not supported.

DATASOURCE_NAME

DBTYPE_WSTR

The name of the data source object.

DATASOURCE_TYPE

DBTYPE_WSTR

The type of the data source. Valid values include:

  • Relational

  • Olap

CREATED_ON

DBTYPE_DBTIMESTAMP

The date that the data source was created.

LAST_SCHEMA_UPDATE

DBTYPE_DBTIMESTAMP

The date and time that the data source was last modified.

DESCRIPTION

DBTYPE_WSTR

A user-friendly description of the action.

TIMEOUT

DBTYPE_UI4

The 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 name

Type indicator

Restriction State

CATALOG_NAME

DBTYPE_WSTR

Optional.

SCHEMA_NAME

DBTYPE_WSTR

Optional.

DATASOURCE_NAME

DBTYPE_WSTR

Optional.

DATASOURCE_TYPE

DBTYPE_WSTR

Optional.

Community Additions

ADD
Show:
© 2015 Microsoft