Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MDSCHEMA_INPUT_DATASOURCES Rowset

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