SYSTEMTABLES: Data Dictionary Tables
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: Tables
Tables, function tables and views per active data container.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SYSTEMTABLES sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CACHE_ |
char |
Cache-Ergebnis | Whether the result of the execution can be cached for the lifetime of the statement. | ||
CALL_ |
varchar2 |
Anruf Sicherer Name | Name for use within SQL with special characters escaped. | ||
CAN_ |
char |
Kann löschen | Indicator whether you can delete data in this table. | ||
CAN_ |
char |
Kann einfügen | Indicator whether you can insert data in this table. | ||
CAN_ |
char |
Kann auswählen | Indicator whether you can select data in this table. | ||
CAN_ |
char |
Kann aktualisieren | Indicator whether you can update data in this table. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the tables are contained in. | ||
CLIENT_ |
char |
Clientseitig cachebar | Are the contents eligible for caching on the client? | ||
CREATION_ |
datetime |
Datum erstellen | Date at which the table was originally created (UTC). | ||
DESCRIPTION |
varchar2 |
Description | Description of the contents. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
EDI_ |
varchar2 |
EDI-Klassenname | EDI: master class name. | ||
EDI_ |
varchar2 |
EDI-Pfad vom Master | EDI: path from the master instance. | ||
ESTIMATED_ |
int64 |
Geschätzte Reihenanzahl | Estimated number of rows in this table per partition. | ||
ESTIMATED_ |
int64 |
Geschätzte Größe in Byte | Estimated size in bytes of this table per partition. | ||
EXAMPLE |
varchar2 |
Example | Example of the contents. | ||
FULL_ |
varchar2 |
Vollständiger qualifizierter Name | Fully qualified name. | ||
FULL_ |
double |
Vollständige Scans Verstrichene Zeit (ms) | Time elapsed during full scans (ms). | ||
FULL_ |
int32 |
Vollständige Scans ausgeführt | Number of full scans executed. | ||
FULL_ |
int64 |
Vollständiger Scan (Zeilen) | Number of full scans row processed. | ||
ID |
int32 |
ID | Unique ID of the table. | ||
IS_ |
char |
Ist Partitionsspezifisch | Indicator whether the contents of this table typically differ per partition. | ||
LABEL_ |
varchar2 |
Beschreibung für Liste | Label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Liste der übersetzten Etiketten | Translated label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Bezeichnung Mehrzahl | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Übersetzte Bezeichnung Mehrzahl | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Bezeichnung Singular | Label of the table contents in singular form. | ||
LABEL_ |
varchar2 |
Übersetzte Bezeichnung (Einzelform) | Translated label of the table contents in singular form. | ||
LAST_ |
datetime |
Letztes Aktualisierungsdatum | Date at which the table's structure was last modified (UTC). | ||
MEASURED_ |
double |
Gemessene durchschnittliche Zugriffsverzögerung (ms) | Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
MEASURED_ |
int32 |
Gemessene durchschnittliche Anzahl der Zeilen pro Minute bei vollständigem Scan | Measured average number of rows that fetched per minute on a full table scan. | ||
MEASURED_ |
int32 |
Gemessene durchschnittliche Anzahl von Query-Zeilen pro Minute | Measured average number of rows processed per minute on point queries. | ||
MEASURED_ |
int32 |
Gemessene durchschnittliche Anzahl der pro Minute geschriebenen Zeilen | Measured average number of rows written per minute. | ||
NAME |
varchar2 |
Name | Name of the table or view. | ||
ODATA_ |
varchar2 |
OData-Basispfad | OData: base path. | ||
ODATA_ |
varchar2 |
Methode zur Auswahl von OData-Feldern | OData: field selection method. | ||
ODATA_ |
varchar2 |
OData-Metadaten-URL | OData: URL for retrieving metadata. | ||
ODATA_ |
varchar2 |
OData-Filter auf Serverseite | OData: text representation of server-side filters. | ||
ODATA_ |
varchar2 |
OData-Dienst-URL für „Löschen“ | OData: service URL for deleting data. | ||
ODATA_ |
varchar2 |
OData-Dienst-URL für „Einfügen“ | OData: service URL for inserting data. | ||
ODATA_ |
varchar2 |
OData-Dienst-URL für „Select“ | OData: service URL for retrieving data. | ||
ODATA_ |
varchar2 |
OData-Dienst-URL für die Aktualisierung | OData: service URL for updating data. | ||
POINT_ |
double |
Zeitaufwand für Punkt-Queries (ms) | Time elapsed during point queries (ms). | ||
POINT_ |
int32 |
Zeilenabfragen nach Punkten | Number of point queries executed. | ||
PRIMARY_ |
varchar2 |
Primärschlüsselspalten | Primary key column(s) of the table. | ||
PROVIDER_ |
varchar2 |
Datencontaineralias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datenkontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Treiberbeschreibung | Provider description. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Treiber Kurzname | Provider short name. | ||
SCHEMA |
varchar2 |
Schema | Schema within the catalog where the table is contained in. | ||
SHORT_ |
varchar2 |
Kurzname | Typical alias for the table. | ||
SOAP_ |
varchar2 |
SOAP-Aktion | SOAP: action. | ||
STATIC_ |
double |
Statische durchschnittliche Zugriffsverzögerung (ms) | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
STATIC_ |
int32 |
Statischer Durchschnittswert der Zeilen pro Minute bei einem vollständigen Scan | Average number of rows that fetched per minute on a full table scan, statically configured. | ||
STATIC_ |
int32 |
Statischer Durchschnittswert der Zeilen pro Minute bei einer Punkt-Query | Average number of rows processed per minute on point queries, statically configured. | ||
STATIC_ |
int32 |
Statischer Durchschnitt der pro Minute geschriebenen Zeilen | Average number of rows written per minute, statically configured. | ||
SWAGGER_ |
varchar2 |
Swagger-Inhaltstyp | SWAGGER: content type. | ||
SWAGGER_ |
varchar2 |
Swagger Löschoperation | SWAGGER: delete operation. | ||
SWAGGER_ |
varchar2 |
Swagger Anlegeoperation | SWAGGER: insert operation. | ||
SWAGGER_ |
varchar2 |
Swagger Pre-Mapping Tabelle Name | SWAGGER: pre-mapping table name. | ||
SWAGGER_ |
varchar2 |
Swagger-Antwortschema | SWAGGER: response schema. | ||
SWAGGER_ |
varchar2 |
Swagger Abrufoperation | SWAGGER: select operation. | ||
SWAGGER_ |
varchar2 |
Swagger Aktualisierungsoperation | SWAGGER: update operation. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TECHNICAL_ |
varchar2 |
Technische Dokumentation | 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 Schlüsselspalte | Key column on webhook messages. | ||
WEBHOOK_ |
varchar2 |
Topic | Webhook topic. | ||
WRITES_ |
int32 |
Ausgeführte Schreibvorgänge | Number of writes executed. | ||
WRITE_ |
double |
Verstrichene Schreibzeit (ms) | Time elapsed during point queries (ms). | ||
WRITTEN_ |
int64 |
Zeilen geschrieben | Number of rows written. | ||
XML_ |
varchar2 |
Basis-XPath | XML: XPath expression which forms the root containing all rows. | ||
XML_ |
varchar2 |
Standard-Namespace Präfix | XML: default namespace prefix. | ||
XML_ |
varchar2 |
Benannter komplexer Typ | XML: name of the complex type. | ||
XML_ |
varchar2 |
Serverseitige Filter | XML: text representation of server-side filters. | ||
XML_ |
varchar2 |
Dienst-URI | 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. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
CATALOG |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
SCHEMA |
SYSTEMSCHEMAS.NAME |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Verwiesen von
- 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)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: