---
title: "SYSTEMDATABASES (Data Dictionary)"
description: "Databases"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMDATABASES
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMDATABASES
updated: 2026-11-16T20:44:59Z
license: https://documentation.invantive.eu/de/
---

# SYSTEMDATABASES: Data Dictionary Databases

`read only`

- Katalog: `DataDictionary`
- Schema: `Invantive`
- Label: Databases

Database information.

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `SYSTEMDATABASES` 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 |
|---|---|---|:---:|---|---|
| `ALLOWS_SQL_TRACE` | `boolean` | Ermöglicht SQL Trace | [ ] |  | Whether the database allows SQL trace. |
| `AUTHENTICATION_MODE` | `varchar2(30)` | Authentifizierungsmodus | [ ] |  | Mode to authenticate using. |
| `COMMENT` | `varchar2(1000)` | Comment | [ ] |  | Comment of the database. |
| `CREATED_BY` | `varchar2(240)` | Erstellt durch | [ ] |  | Whom created the database definition. |
| `CREATED_ON` | `varchar2(240)` | Erstellt am | [ ] |  | On what device the database definition was created. |
| `CREATION_DATE_UTC` | `datetime` | Erstellungsdatum (UTC) | [ ] |  | Moment at which the database definition was created. |
| `DATABASE_NAME` | `varchar2(240)` | Database | [x] |  | Name der Datenbank. |
| `DESCRIPTION` | `varchar2(1000)` | Description | [ ] |  | Description of the database. |
| `DUMMY` | `char` | Dummy | [x] |  | Dummy column. |
| `FORCE_NATIVE` | `boolean` | Erzwinge native | [x] |  | Whether to force a native connection instead of using Invantive SQL. |
| `FULL_NAME` | `varchar2(240)` | Vollständiger Name | [x] |  | Full name of the database. |
| `GROUP_NAME` | `varchar2(240)` | Gruppenname | [x] |  | Name of the database group. |
| `HAS_DATA_CACHE_CONNECTION_STRING` | `boolean` | Hat eine Data Cache-Verbindungszeichenfolge | [x] |  | Whether the database uses Data Cache or Data Replicator. |
| `HAS_DATA_DICTIONARY_CONNECTION_STRING` | `boolean` | Hat eine Datenwörterbuch-Verbindungszeichenfolge | [x] |  | Whether the database uses a connection string to store persistent elements of the Data Dictionary. |
| `ID` | `guid` | ID | [x] |  | Unique ID. |
| `IS_DISTRIBUTED` | `boolean` | Ist verteilt | [x] |  | Whether the database is distributed. |
| `IS_STARRED` | `boolean` | Ist mit einem Stern versehen | [ ] |  | Whether the database definition is starred as a favorite. |
| `LAST_AUTHENTICATION_TIME_UTC` | `datetime` | Letzte Authentifizierungszeit | [x] |  | Moment at which the authentication completed last. |
| `MANUALLY_ADAPTED` | `boolean` | Manuell angepasst | [x] |  | Whether the database definition was manually adapted. |
| `REGISTRATION_MOMENT_UTC` | `datetime` | Registrierungszeitpunkt | [ ] |  | Moment at which the database was registered in the working memory. |
| `REMOTE_AUTHENTICATION_MODE` | `varchar2(30)` | Modus für Fernauthentifizierung | [ ] |  | Remote mode to authenticate using. |
| `REQUIRES_INVANTIVE_SQL` | `boolean` | Erfordert Invantive UniversalSQL | [x] |  | Whether the database requires use of Invantive SQL. |
| `SETTINGS_FILE_LAST_MODIFIED_UTC` | `datetime` | Letzte Änderung der Einstellungsdatei | [ ] |  | Moment at which the settings file was last modified. |
| `SETTINGS_FILE_NAME_PATH` | `varchar2(240)` | Pfad des Dateinamens der Einstellungen | [ ] |  | Name and path of the settings.xml file. |
| `SHORT_DESCRIPTION` | `varchar2(240)` | Kurze Beschreibung | [ ] |  | Short description of the database. |
| `SORTING_ORDER` | `int32` | Sortierungsrichtung | [x] |  | Sorting order of the database within the group. |


## 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)
