mdschema-input-datasources-rowset.md

title	MDSCHEMA_INPUT_DATASOURCES Rowset | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	MDSCHEMA_INPUT_DATASOURCES
apitype	NA
applies_to	SQL Server 2016 Preview
helpviewer_keywords	MDSCHEMA_INPUT_DATASOURCES rowset
ms.assetid	12482fd5-16e3-4171-9cb0-76d0d4f5308e
caps.latest.revision	30
author	Minewiskan
ms.author	owend
manager	erikre

MDSCHEMA_INPUT_DATASOURCES Rowset

Describes the data sources defined within the database.

Rowset Columns

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.

Restriction Columns

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.

See Also

OLE DB for OLAP Schema Rowsets