This topic has not yet been rated - Rate this topic

MDSCHEMA_INPUT_DATASOURCES Rowset

SQL Server 2005

Describes the data sources defined within the database.

The MDSCHEMA_INPUT_DATASOURCES rowset contains the following columns.

Column name	Type indicator	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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions