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