Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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:
|
|
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
Reference
OLE DB for OLAP Schema Rowsets