SYSTEMTABLES: Data Dictionary Tables
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Tables
Tables, function tables and views per active data container.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMTABLES worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CACHE_ |
char |
Cacheresultaat | Whether the result of the execution can be cached for the lifetime of the statement. | ||
CALL_ |
varchar2 |
Veilig Naam voor Aanroep | Name for use within SQL with special characters escaped. | ||
CAN_ |
char |
Kan Verwijderen | Indicator whether you can delete data in this table. | ||
CAN_ |
char |
Kan Invoegen | Indicator whether you can insert data in this table. | ||
CAN_ |
char |
Kan Selecteren | Indicator whether you can select data in this table. | ||
CAN_ |
char |
Kan Bijwerken | Indicator whether you can update data in this table. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the tables are contained in. | ||
CLIENT_ |
char |
Clientzijde Cachebaar | Are the contents eligible for caching on the client? | ||
CREATION_ |
datetime |
Aanmaakdatum | Date at which the table was originally created (UTC). | ||
DESCRIPTION |
varchar2 |
Description | Description of the contents. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
EDI_ |
varchar2 |
EDI-klassenaam | EDI: master class name. | ||
EDI_ |
varchar2 |
EDI pad van Master | EDI: path from the master instance. | ||
ESTIMATED_ |
int64 |
Geschat Aantal Rijen | Estimated number of rows in this table per partition. | ||
ESTIMATED_ |
int64 |
Geschatte Omvang in Bytes | Estimated size in bytes of this table per partition. | ||
EXAMPLE |
varchar2 |
Example | Example of the contents. | ||
FULL_ |
varchar2 |
Volledig Gekwalificeerde Naam | Fully qualified name. | ||
FULL_ |
double |
Volledige Scans Verstreken Tijd (ms) | Time elapsed during full scans (ms). | ||
FULL_ |
int32 |
Volledige Scans Uitgevoerd | Number of full scans executed. | ||
FULL_ |
int64 |
Volledige Scan (rijen) | Number of full scans row processed. | ||
ID |
int32 |
ID | Unique ID of the table. | ||
IS_ |
char |
Is Partitie Specifiek | Indicator whether the contents of this table typically differ per partition. | ||
LABEL_ |
varchar2 |
Label voor Lijst | Label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Vertaalde Labellijst | Translated label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Label Meervoud | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Vertaald Label Meervoud | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Label Enkelvoud | Label of the table contents in singular form. | ||
LABEL_ |
varchar2 |
Vertaald Label Enkelvoud | Translated label of the table contents in singular form. | ||
LAST_ |
datetime |
Laatst Bijgewerkt Datum | Date at which the table's structure was last modified (UTC). | ||
MEASURED_ |
double |
Gemeten Gemiddelde Toegangsvertraging (ms) | Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
MEASURED_ |
int32 |
Gewogen Gemiddeld Nummer Volledige Scan Rijen per Minuut | Measured average number of rows that fetched per minute on a full table scan. | ||
MEASURED_ |
int32 |
Gewogen Gemiddeld Nummer Punt Query Rijen per Minuut | Measured average number of rows processed per minute on point queries. | ||
MEASURED_ |
int32 |
Gemeten Gemiddeld Nummer Rijen Geschreven per Minuut | Measured average number of rows written per minute. | ||
NAME |
varchar2 |
Name | Name of the table or view. | ||
ODATA_ |
varchar2 |
OData Basispad | OData: base path. | ||
ODATA_ |
varchar2 |
OData Veldselectiemethode | OData: field selection method. | ||
ODATA_ |
varchar2 |
OData Metadata URL | OData: URL for retrieving metadata. | ||
ODATA_ |
varchar2 |
OData Filters aan Serverzijde | OData: text representation of server-side filters. | ||
ODATA_ |
varchar2 |
OData Service URL voor Verwijderen | OData: service URL for deleting data. | ||
ODATA_ |
varchar2 |
OData Service URL voor Toevoegen | OData: service URL for inserting data. | ||
ODATA_ |
varchar2 |
OData Service URL voor Ophalen | OData: service URL for retrieving data. | ||
ODATA_ |
varchar2 |
OData Service URL voor Bijwerken | OData: service URL for updating data. | ||
POINT_ |
double |
Tijd besteed aan Puntqueries (ms) | Time elapsed during point queries (ms). | ||
POINT_ |
int32 |
Rijen via Puntqueries | Number of point queries executed. | ||
PRIMARY_ |
varchar2 |
Primaire Sleutelkolommen | Primary key column(s) of the table. | ||
PROVIDER_ |
varchar2 |
Datacontainer Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datacontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provideromschrijving | Provider description. | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Providernaam | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Korte Naam | Provider short name. | ||
SCHEMA |
varchar2 |
Schema | Schema within the catalog where the table is contained in. | ||
SHORT_ |
varchar2 |
Korte Naam | Typical alias for the table. | ||
SOAP_ |
varchar2 |
SOAP Actie | SOAP: action. | ||
STATIC_ |
double |
Statisch Gemiddelde Toegangswachttijd (ms) | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
STATIC_ |
int32 |
Statisch Gemiddelde Aantal Rijen per Minuut bij Volledig Scannen | Average number of rows that fetched per minute on a full table scan, statically configured. | ||
STATIC_ |
int32 |
Statisch Gemiddelde Aantal Rijen per Minuut op Puntquery | Average number of rows processed per minute on point queries, statically configured. | ||
STATIC_ |
int32 |
Statisch Gemiddeld Aantal Rijen Schrijven per Minuut | Average number of rows written per minute, statically configured. | ||
SWAGGER_ |
varchar2 |
Swagger Inhoudssoort | SWAGGER: content type. | ||
SWAGGER_ |
varchar2 |
Swagger Verwijderoperatie | SWAGGER: delete operation. | ||
SWAGGER_ |
varchar2 |
Swagger Toevoegoperatie | SWAGGER: insert operation. | ||
SWAGGER_ |
varchar2 |
Swagger Pre-mapping Tabelnaam | SWAGGER: pre-mapping table name. | ||
SWAGGER_ |
varchar2 |
Swagger Antwoordschema | SWAGGER: response schema. | ||
SWAGGER_ |
varchar2 |
Swagger Selecteeroperatie | SWAGGER: select operation. | ||
SWAGGER_ |
varchar2 |
Swagger Bijwerkoperatie | SWAGGER: update operation. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TECHNICAL_ |
varchar2 |
Technische Documentatie | 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 Sleutelkolom | Key column on webhook messages. | ||
WEBHOOK_ |
varchar2 |
Topic | Webhook topic. | ||
WRITES_ |
int32 |
Schrijfacties Uitgevoerd | Number of writes executed. | ||
WRITE_ |
double |
Verstreken Schrijftijd (ms) | Time elapsed during point queries (ms). | ||
WRITTEN_ |
int64 |
Rijen Geschreven | Number of rows written. | ||
XML_ |
varchar2 |
Basis XPath | XML: XPath expression which forms the root containing all rows. | ||
XML_ |
varchar2 |
Standaard Naamruimte Voorvoegsel | XML: default namespace prefix. | ||
XML_ |
varchar2 |
Benoemd Complex Type | XML: name of the complex type. | ||
XML_ |
varchar2 |
Serverzijde 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. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
CATALOG |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
SCHEMA |
SYSTEMSCHEMAS.NAME |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Geciteerd door
- 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
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: