Tables, function tables and views per active data container.
Catalog: DataDictionary
Schema: Invantive
Alias: tbe
Label: Tables
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view SYSTEMTABLES are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CACHE_RESULT |
boolean |
Cache Result |
☐ |
Whether the result of the execution can be cached for the lifetime of the statement. |
CALL_SAFE_NAME |
string |
Call Safe Name |
|
Name for use within SQL with special characters escaped. |
CAN_DELETE |
boolean |
Can Delete |
|
Indicator whether you can delete data in this table. |
CAN_INSERT |
boolean |
Can Insert |
|
Indicator whether you can insert data in this table. |
CAN_SELECT |
boolean |
Can Select |
|
Indicator whether you can select data in this table. |
CAN_UPDATE |
boolean |
Can Update |
|
Indicator whether you can update data in this table. |
CATALOG |
string |
Catalog |
|
Catalog where the tables are contained in. |
CLIENT_SIDE_CACHEABLE |
boolean |
Client-Side Cacheable |
|
Are the contents eligible for caching on the client? |
CREATION_DATE_UTC |
datetime |
Creation Date |
|
Date at which the table was originally created (UTC). |
DESCRIPTION |
string |
Description |
|
Description of the contents. |
DOCUMENTATION |
string |
Documentation |
|
Documentation. |
EDI_CLASS_NAME |
string(240) |
EDI Class Name |
☐ |
EDI: master class name. |
EDI_PATH_FROM_MASTER |
string(240) |
EDI Path from Master |
☐ |
EDI: path from the master instance. |
ESTIMATED_NUMBER_OF_ROWS |
int64 |
Estimated Number of Rows |
|
Estimated number of rows in this table per partition. |
ESTIMATED_SIZE_BYTES |
int64 |
Estimated Size in Bytes |
|
Estimated size in bytes of this table per partition. |
EXAMPLE |
string |
Example |
|
Example of the contents. |
FULL_QUALIFIED_NAME |
string |
Full Qualified Name |
|
Fully qualified name. |
FULL_SCAN_ROWS |
int32 |
Full Scan (rows) |
|
Number of full scans row processed. |
FULL_SCANS_ELAPSED_TIME_MS |
int32 |
Full Scans Elapsed Time (ms) |
|
Time elapsed during full scans (ms). |
FULL_SCANS_EXECUTED |
int32 |
Full Scans Executed |
|
Number of full scans executed. |
ID |
int32 |
ID |
|
Unique ID of the table. |
IS_PARTITION_SPECIFIC |
boolean |
Is Partition Specific |
|
Indicator whether the contents of this table typically differ per partition. |
LABEL_LIST_I18N |
string |
Translated Label List |
|
Translated label of the table for use in lists. |
LABEL_LIST |
string |
Label for List |
|
Label of the table for use in lists. |
LABEL_PLURAL_I18N |
string |
Translated Label Plural |
|
Label of the table contents in plural form. |
LABEL_PLURAL |
string |
Label Plural |
|
Label of the table contents in plural form. |
LABEL_SINGULAR_I18N |
string |
Translated Label Singular |
|
Translated label of the table contents in singular form. |
LABEL_SINGULAR |
string |
Label Singular |
|
Label of the table contents in singular form. |
LAST_UPDATE_DATE_UTC |
datetime |
Last Update Date |
|
Date at which the table's structure was last modified (UTC). |
MEASURED_AVERAGE_ACCESS_LATENCY_MS |
int32 |
Measured Average Access Latency (ms) |
|
Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. |
MEASURED_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE |
int32 |
Measured Average Number Full Scan Row per Minute |
|
Measured average number of rows that fetched per minute on a full table scan. |
MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE |
int32 |
Measured Average Number Point Query Rows per Minute |
|
Measured average number of rows processed per minute on point queries. |
MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE |
int32 |
Measured Average Number Rows Written per Minute |
|
Measured average number of rows written per minute. |
NAME |
string |
Name |
|
Name of the table or view. |
ODATA_BASE_PATH |
string(240) |
OData Base Path |
☐ |
OData: base path. |
ODATA_FIELD_SELECTION_METHOD |
string(240) |
OData Field Selection Method |
☐ |
OData: field selection method. |
ODATA_METADATA_URL |
string(4000) |
OData Metadata URL |
☐ |
OData: URL for retrieving metadata. |
ODATA_SERVER_SIDE_FILTERS |
string |
OData Server-side Filters |
☐ |
OData: text representation of server-side filters. |
ODATA_SERVICE_URL_FOR_DELETE |
string(4000) |
OData Service URL for Delete |
☐ |
OData: service URL for deleting data. |
ODATA_SERVICE_URL_FOR_INSERT |
string(4000) |
OData Service URL for Insert |
☐ |
OData: service URL for inserting data. |
ODATA_SERVICE_URL_FOR_SELECT |
string(4000) |
OData Service URL for Select |
☐ |
OData: service URL for retrieving data. |
ODATA_SERVICE_URL_FOR_UPDATE |
string(4000) |
OData Service URL for Update |
☐ |
OData: service URL for updating data. |
POINT_QUERIES_ELAPSED_TIME_MS |
int32 |
Time Spent in Point Queries (ms) |
|
Time elapsed during point queries (ms). |
POINT_QUERIES_EXECUTED |
int32 |
Rows through Point Queries |
|
Number of point queries executed. |
PRIMARY_KEY_FIELD |
string(4000) |
Primary Key Columns |
|
Primary key column(s) of the table. |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
SCHEMA |
string |
Schema |
|
Schema within the catalog where the table is contained in. |
SHORT_NAME |
string |
Short Name |
|
Typical alias for the table. |
SOAP_ACTION |
string(240) |
SOAP Action |
☐ |
SOAP: action. |
STATIC_AVERAGE_ACCESS_LATENCY_MS |
int32 |
Static Average Access Latency (ms) |
|
Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. |
STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE |
int32 |
Static Average Rows per Minute on Full Scan |
|
Average number of rows that fetched per minute on a full table scan, statically configured. |
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE |
int32 |
Static Average Rows per Minute on Point Query |
|
Average number of rows processed per minute on point queries, statically configured. |
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE |
int32 |
Static Average Rows per Minute Written |
|
Average number of rows written per minute, statically configured. |
SWAGGER_DELETE_OPERATION |
string(240) |
Swagger Delete Operation |
☐ |
SWAGGER: delete operation. |
SWAGGER_INSERT_OPERATION |
string(240) |
Swagger Insert Operation |
☐ |
SWAGGER: insert operation. |
SWAGGER_SELECT_OPERATION |
string(240) |
Swagger Select Operation |
☐ |
SWAGGER: select operation. |
SWAGGER_UPDATE_OPERATION |
string(240) |
Swagger Update Operation |
☐ |
SWAGGER: update operation. |
TABLE_PARAMETERS |
string(4000) |
Parameters |
|
Parameters defined on the table. |
TYPE |
string |
Type |
|
Type, can be either 'view' or 'table'. |
VALID |
boolean |
Valid |
|
Whether the structure of the table is valid. |
WEBHOOK_KEY_FIELD |
string(4000) |
Webhook Key Column |
☐ |
Key column on webhook messages. |
WEBHOOK_TOPIC |
string(4000) |
Topic |
☐ |
Webhook topic. |
WRITE_ELAPSED_TIME_MS |
int32 |
Elapsed Write Time (ms) |
|
Time elapsed during point queries (ms). |
WRITES_EXECUTED |
int32 |
Writes Executed |
|
Number of writes executed. |
WRITTEN_ROWS |
int32 |
Rows Written |
|
Number of rows written. |
XML_BASE_XPATH |
string(240) |
Base XPath |
☐ |
XML: XPath expression which forms the root containing all rows. |
XML_DEFAULT_NAMESPACE_PREFIX |
string(240) |
Default Namespace Prefix |
☐ |
XML: default namespace prefix. |
XML_NAMED_COMPLEX_TYPE |
string(240) |
Named Complex Type |
☐ |
XML: name of the complex type. |
XML_SERVER_SIDE_FILTERS |
string |
Server-side Filters |
☐ |
XML: text representation of server-side filters. |
XML_SERVICE_URL |
string(240) |
Service URL |
☐ |
XML: Service URL. |
XML_TOPIC |
string(240) |
Topic |
☐ |
XML: topic or action as known on the remote server. Defaults to Name when not set. |
XML_XPATH |
string(240) |
XPath |
☐ |
XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath. |
17-05-2021 11:57 Version 20.1.419-BETA+3191