SYSTEMTABLES: Data Dictionary Tables
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Tables
Tables, function tables and views per active data container.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMTABLES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CACHE_ |
char |
Cache Result | Whether the result of the execution can be cached for the lifetime of the statement. | ||
CALL_ |
varchar2 |
Call Safe Name | Name for use within SQL with special characters escaped. | ||
CAN_ |
char |
Can Delete | Indicator whether you can delete data in this table. | ||
CAN_ |
char |
Can Insert | Indicator whether you can insert data in this table. | ||
CAN_ |
char |
Can Select | Indicator whether you can select data in this table. | ||
CAN_ |
char |
Can Update | Indicator whether you can update data in this table. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the tables are contained in. | ||
CLIENT_ |
char |
Client-Side Cacheable | Are the contents eligible for caching on the client? | ||
CREATION_ |
datetime |
Creation Date | Date at which the table was originally created (UTC). | ||
DESCRIPTION |
varchar2 |
Description | Description of the contents. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
EDI_ |
varchar2 |
EDI Class Name | EDI: master class name. | ||
EDI_ |
varchar2 |
EDI Path from Master | EDI: path from the master instance. | ||
ESTIMATED_ |
int64 |
Estimated Number of Rows | Estimated number of rows in this table per partition. | ||
ESTIMATED_ |
int64 |
Estimated Size in Bytes | Estimated size in bytes of this table per partition. | ||
EXAMPLE |
varchar2 |
Example | Example of the contents. | ||
FULL_ |
varchar2 |
Full Qualified Name | Fully qualified name. | ||
FULL_ |
double |
Full Scans Elapsed Time (ms) | Time elapsed during full scans (ms). | ||
FULL_ |
int32 |
Full Scans Executed | Number of full scans executed. | ||
FULL_ |
int64 |
Full Scan (rows) | Number of full scans row processed. | ||
ID |
int32 |
ID | Unique ID of the table. | ||
IS_ |
char |
Is Partition Specific | Indicator whether the contents of this table typically differ per partition. | ||
LABEL_ |
varchar2 |
Label for List | Label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Translated Label List | Translated label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Label Plural | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Translated Label Plural | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Label Singular | Label of the table contents in singular form. | ||
LABEL_ |
varchar2 |
Translated Label Singular | Translated label of the table contents in singular form. | ||
LAST_ |
datetime |
Last Update Date | Date at which the table's structure was last modified (UTC). | ||
MEASURED_ |
double |
Measured Average Access Latency (ms) | Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
MEASURED_ |
int32 |
Measured Average Number Full Scan Row per Minute | Measured average number of rows that fetched per minute on a full table scan. | ||
MEASURED_ |
int32 |
Measured Average Number Point Query Rows per Minute | Measured average number of rows processed per minute on point queries. | ||
MEASURED_ |
int32 |
Measured Average Number Rows Written per Minute | Measured average number of rows written per minute. | ||
NAME |
varchar2 |
Name | Name of the table or view. | ||
ODATA_ |
varchar2 |
OData Base Path | OData: base path. | ||
ODATA_ |
varchar2 |
OData Field Selection Method | OData: field selection method. | ||
ODATA_ |
varchar2 |
OData Metadata URL | OData: URL for retrieving metadata. | ||
ODATA_ |
varchar2 |
OData Server-side Filters | OData: text representation of server-side filters. | ||
ODATA_ |
varchar2 |
OData Service URL for Delete | OData: service URL for deleting data. | ||
ODATA_ |
varchar2 |
OData Service URL for Insert | OData: service URL for inserting data. | ||
ODATA_ |
varchar2 |
OData Service URL for Select | OData: service URL for retrieving data. | ||
ODATA_ |
varchar2 |
OData Service URL for Update | OData: service URL for updating data. | ||
POINT_ |
double |
Time Spent in Point Queries (ms) | Time elapsed during point queries (ms). | ||
POINT_ |
int32 |
Rows through Point Queries | Number of point queries executed. | ||
PRIMARY_ |
varchar2 |
Primary Key Columns | Primary key column(s) of the table. | ||
PROVIDER_ |
varchar2 |
Data Container Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Data Container ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provider Description | Provider description. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Provider short name. | ||
SCHEMA |
varchar2 |
Schema | Schema within the catalog where the table is contained in. | ||
SHORT_ |
varchar2 |
Short Name | Typical alias for the table. | ||
SOAP_ |
varchar2 |
SOAP Action | SOAP: action. | ||
STATIC_ |
double |
Static Average Access Latency (ms) | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
STATIC_ |
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_ |
int32 |
Static Average Rows per Minute on Point Query | Average number of rows processed per minute on point queries, statically configured. | ||
STATIC_ |
int32 |
Static Average Rows per Minute Written | Average number of rows written per minute, statically configured. | ||
SWAGGER_ |
varchar2 |
Swagger Content Type | SWAGGER: content type. | ||
SWAGGER_ |
varchar2 |
Swagger Delete Operation | SWAGGER: delete operation. | ||
SWAGGER_ |
varchar2 |
Swagger Insert Operation | SWAGGER: insert operation. | ||
SWAGGER_ |
varchar2 |
Swagger Pre Mapping Table Name | SWAGGER: pre-mapping table name. | ||
SWAGGER_ |
varchar2 |
Swagger Response Schema | SWAGGER: response schema. | ||
SWAGGER_ |
varchar2 |
Swagger Select Operation | SWAGGER: select operation. | ||
SWAGGER_ |
varchar2 |
Swagger Update Operation | SWAGGER: update operation. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TECHNICAL_ |
varchar2 |
Technical Documentation | Technical documentation. | ||
TYPE |
varchar2 |
Type | Type, can be either 'view' or 'table'. | ||
VALID |
char |
Valid | Whether the structure of the table is valid. | ||
WEBHOOK_ |
varchar2 |
Webhook Key Column | Key column on webhook messages. | ||
WEBHOOK_ |
varchar2 |
Topic | Webhook topic. | ||
WRITES_ |
int32 |
Writes Executed | Number of writes executed. | ||
WRITE_ |
double |
Elapsed Write Time (ms) | Time elapsed during point queries (ms). | ||
WRITTEN_ |
int64 |
Rows Written | Number of rows written. | ||
XML_ |
varchar2 |
Base XPath | XML: XPath expression which forms the root containing all rows. | ||
XML_ |
varchar2 |
Default Namespace Prefix | XML: default namespace prefix. | ||
XML_ |
varchar2 |
Named Complex Type | XML: name of the complex type. | ||
XML_ |
varchar2 |
Server-side Filters | XML: text representation of server-side filters. | ||
XML_ |
varchar2 |
Service URL | XML: Service URL. | ||
XML_ |
varchar2 |
Topic | XML: topic or action as known on the remote server. Defaults to Name when not set. | ||
XML_ |
varchar2 |
XPath | XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
CATALOG |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
SCHEMA |
SYSTEMSCHEMAS.NAME |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Referenced By
- SYSTEMTABLECOLUMNS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLECOLUMNS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLECOLUMNS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLECOLUMNS
TABLE_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_NAME(Key) - SYSTEMTABLEKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEKEYS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEKEYS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEKEYS
TABLE_NAME(Key) - SYSTEMVIEWS
PROVIDER_INSTANCE_UID(Key) - SYSTEMVIEWS
CATALOG(Key) - SYSTEMVIEWS
SCHEMA(Key) - SYSTEMVIEWS
NAME(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: