---
title: "SYSTEMTABLECOLUMNSLIVE (Data Dictionary)"
description: "Live Retrieved Table Columns"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNSLIVE
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMTABLECOLUMNSLIVE
updated: 2026-11-16T20:45:43Z
license: https://documentation.invantive.eu/de/
---

# SYSTEMTABLECOLUMNSLIVE: Data Dictionary Live Retrieved Table Columns

`read only`

- Katalog: `DataDictionary`
- Schema: `Invantive`
- Label: Live Retrieved Table Columns

Live retrieval of the available columns per table per data container.

Es können nur Daten abgerufen werden.

## Zusammenfassung

Availability varies per platform.

## Tabellenspalten

Die Spalten der Tabelle `SYSTEMTABLECOLUMNSLIVE` 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 |
|---|---|---|:---:|---|---|
| `CLIENT_SIDE_CACHEABLE` | `char` | Table Client-Side Cacheable | [ ] |  | Are the contents eligible for caching on the client? |
| `DATABASE_DATA_TYPE` | `varchar2` | Datenbank Datentyp | [ ] |  | Data type in the database. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Datencontaineralias | [ ] |  | Alias of the data container. |
| `DOCUMENTATION` | `varchar2` | Documentation | [ ] |  | Documentation. |
| `DOTNET_DATA_TYPE` | `varchar2` | .NET Datentyp | [ ] |  | Data type for .NET. |
| `GET_VALUE` | `varchar2` | Wert abholen | [ ] |  | Function used for post-processing. |
| `ID` | `int32` | ID | [ ] |  | Unique ID of the column. |
| `IS_NEW` | `char` | Ist neu | [ ] |  | Is the field new. |
| `LABEL_SINGULAR` | `varchar2` | Bezeichnung Singular | [ ] |  | Human-readable label in singular form. |
| `MAX_LENGTH` | `int64` | Maximale Länge | [ ] |  | Maximum length. |
| `NAME` | `varchar2` | Name | [ ] |  | Name of the column. |
| `NULLABLE` | `char` | Nullable | [ ] |  | Whether the value is optional. |
| `POST_PROCESS_GET_VALUE` | `varchar2` | Nachbearbeitung Get-Wert | [ ] |  | Whether the value is completed by Invantive after processing. |
| `PRECISION` | `int64` | Precision | [ ] |  | Precision. |
| `PROVIDER_INSTANCE_UID` | `guid` | Treiber Instanz-UID | [x] |  | Unique ID of the provider instance. |
| `SCALE` | `int64` | Scale | [ ] |  | Scale. |
| `SERVICE_URL` | `varchar2` | URL | [ ] |  | URL being accessed |
| `TABLE_CALL_SAFE_NAME` | `varchar2` | Table Call Safe Name | [ ] |  | Name for use within SQL with special characters escaped. |
| `TABLE_CAN_DELETE` | `char` | Table Can Delete | [ ] |  | Indicator whether you can delete data in this table. |
| `TABLE_CAN_INSERT` | `char` | Table Can Insert | [ ] |  | Indicator whether you can insert data in this table. |
| `TABLE_CAN_SELECT` | `char` | Table Can Select | [ ] |  | Indicator whether you can select data in this table. |
| `TABLE_CAN_UPDATE` | `char` | Table Can Update | [ ] |  | Indicator whether you can update data in this table. |
| `TABLE_CATALOG_NAME` | `varchar2` | Table Catalog | [ ] |  | Catalog where the tables are contained in. |
| `TABLE_CREATION_DATE_UTC` | `datetime` | Table Creation Date | [ ] |  | Date at which the table was originally created (UTC). |
| `TABLE_DESCRIPTION` | `varchar2` | Tabelle Beschreibung | [ ] |  | Description of the contents. |
| `TABLE_DOCUMENTATION` | `varchar2` | Table Documentation | [ ] |  | Documentation of the table or view. |
| `TABLE_ESTIMATED_NUMBER_OF_ROWS` | `int64` | Table Estimated Number of Rows | [ ] |  | Estimated number of rows in this table per partition |
| `TABLE_ESTIMATED_SIZE_BYTES` | `int64` | Table Estimated Size in Bytes | [ ] |  | Estimated size in bytes of this table per partition. |
| `TABLE_EXAMPLE` | `varchar2` | Table Example | [ ] |  | Example of the contents. |
| `TABLE_IS_NEW` | `char` | Tabelle ist neu | [ ] |  | Is the table new. |
| `TABLE_IS_PARTITION_SPECIFIC` | `char` | Table Is Partition Specific | [ ] |  | Indicator whether the contents of this table typically differ per partition. |
| `TABLE_LABEL_LIST` | `varchar2` | Table Label for List | [ ] |  | Label of the table for use in lists. |
| `TABLE_LABEL_PLURAL` | `varchar2` | Table Label Plural | [ ] |  | Label of the table contents in plural form. |
| `TABLE_LABEL_SINGULAR` | `varchar2` | Table Label Singular | [ ] |  | Label of the table contents in singular form. |
| `TABLE_LAST_UPDATE_DATE_UTC` | `datetime` | Table Last Update Date | [ ] |  | Date at which the table's structure was last modified (UTC). |
| `TABLE_NAME` | `varchar2` | Tabelle Name | [ ] |  | Name of the table or view. |
| `TABLE_PRIMARY_KEY_FIELD` | `varchar2` | Table Primary Key | [ ] |  | The primary key field of the table. |
| `TABLE_SCHEMA_NAME` | `varchar2` | Table Schema | [ ] |  | Schema within the catalog where the table is contained in. |
| `TABLE_SHORT_NAME` | `varchar2` | Table Short Name | [ ] |  | Typical alias for the table. |
| `TABLE_TYPE` | `varchar2` | Tabellentyp | [ ] |  | Type, can be either 'view' or 'table'. |
| `TABLE_VALID` | `char` | Table Valid | [ ] |  | Whether the structure of the table is valid. |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Data Dictionary](/de/release-notes/drivers?driver=data-dictionary)
