Table Metadata
SYS.Tables
This table supplies information about all the groups (tables, views, documents, etc.) in the virtual database.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Short group name |
| string | Table type (Table, View, Document, etc.) |
| string | Name of this group in the source |
| boolean |
|
| boolean |
|
| string | Group unique ID |
| integer | Approximate number of rows in the group |
| string | Description set at the CData Virtuality Server |
OriginalDescription | string | Description from the data source |
| boolean |
|
IsMaterialized | boolean | Defines whether the corresponding table/view is materialized or cached in Teiid |
| integer | Unique ID* |
* The OID column is guaranteed to be unique/consistent unsafe-only for the given version running instance of a VDB. If a different version of the VDB is deployed, these IDs are not guaranteed to be the same or unique across both versions of the VDB. Dynamic VDB OIDs are not cluster-safe.
SYSADMIN.MatViews
This table supplies information about all the materialized views in the virtual database.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Short group name |
| string | Name of the materialized table schema |
| string | Name of the materialized table |
| boolean |
|
| boolean | Load state, can be one of |
| timestamp | Timestamp of the last full refresh |
| integer | Number of rows in the materialized view table |
SYS.Columns
This table supplies information about the virtual database's elements (columns, tags, attributes, etc.).
Column Name | Type | Description |
---|---|---|
VDBName | string | VDB name |
| string | Schema name |
| string | Table name |
| string | Element name (not qualified) |
| integer | Position in the group (1-based) |
| string | Name of the element in the source |
| string | CData Virtuality Server runtime data type name |
| integer | Number of digits after the decimal point |
| integer | Element length (mostly used for strings) |
| boolean | Whether the length is fixed or variable |
| boolean | Element can be used in |
| boolean | Values can be inserted or updated in the element |
| boolean | Element is case-sensitive |
| boolean | Element is a signed numeric value |
| boolean | Element represents monetary value |
| boolean | Element is auto-incremented in the source |
| string | Nullability: " |
| string | Minimum value |
| string | Maximum value |
| integer | Distinct value count, |
| integer | Null value count, |
| string | Searchability: " |
| string | Format of the string value |
| string | Default value |
| string | Java class that will be returned |
| integer | Number of digits as a numeric value |
| integer | Measure of return value size |
| integer | Radix for numeric values |
| string | Element unique ID |
Description | string | Description set at the CData Virtuality Server |
OriginalDescription | string | Description from the data source |
| integer | Unique ID* |
NativeType | string | Data source native data type |
NativePrecision | integer | Data source native precision |
NativeScale | integer | Data source native scale |
NativeLength | integer | Data source native length |
ColumnSize | integer |
|
* The OID column is guaranteed to be unique/consistent unsafe-only for the given version running instance of a VDB. If a different version of the VDB is deployed, these IDs are not guaranteed to be the same or unique across both versions of the VDB. Dynamic VDB OIDs are not cluster-safe.
Native information for JDBC data sources is presented as provided by their JDBC drivers.
SYS.Keys
This table supplies information about primary, foreign, and unique keys.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Table name |
| string | Key name |
| string | Description |
| string | Name of key in source system |
| string | Type of key: " |
| boolean |
|
| string | Referenced key UID (if foreign key) |
| string | Key unique ID |
| integer | Unique ID* |
* The OID column is guaranteed to be unique/consistent unsafe-only for the given version running instance of a VDB. If a different version of the VDB is deployed, these IDs are not guaranteed to be the same or unique across both versions of the VDB. Dynamic VDB OIDs are not cluster-safe.
SYS.KeyColumns
This table supplies information about the columns referenced by a key.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Table name |
| string | Element name |
| string | Key name |
| string | Key type: " |
| string | Referenced key UID |
| string | Key UID |
| integer | Position in key |
| integer | Unique ID* |
* The OID column is guaranteed to be unique/consistent unsafe-only for the given version running instance of a VDB. If a different version of the VDB is deployed, these IDs are not guaranteed to be the same or unique across both versions of the VDB. Dynamic VDB OIDs are not cluster-safe.
SYS.ReferenceKeyColumns
Column Name | Type | Description |
---|---|---|
| string | Primary key catalogue |
| string | Primary key schema |
| string | Primary key table |
| string | Primary key column name |
| string | Foreign key catalogue |
| string | Foreign key schema |
| string | Foreign key table |
| string | Foreign key column name |
| short | Key sequence |
| integer | Update rule |
DELETE_RULE | integer | Delete rule |
FK_NAME | string | Foreign key name |
PK_NAME | string | Primary key name |
DEFERRABILITY | integer | Deferrability |
SYSADMIN.Remarks
This table supplies information about the remarks created for data source objects in CData Virtuality Server.
Column Name | Type | Description |
---|---|---|
| string | Remark ID |
| string | Name of the object the remark is issued for |
| string | Type of object with the remark (i.e. table, procedure, table_column, etc.) |
| string | Remark text |
| boolean | Flag indicating if the remark is obsolete |