invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMDATABASES: Data Dictionary Databases

read only

  • Catalogus: DataDictionary
  • Schema: Invantive
  • Label: Databases

Database information.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMDATABASES 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
ALLOWS_SQL_TRACE boolean Toestaan SQL Trace Whether the database allows SQL trace.
AUTHENTICATION_MODE varchar2(30) Authenticatiemodus Mode to authenticate using.
COMMENT varchar2(1000) Comment Comment of the database.
CREATED_BY varchar2(240) Gemaakt door Whom created the database definition.
CREATED_ON varchar2(240) Aangemaakt op On what device the database definition was created.
CREATION_DATE_UTC datetime Aanmaakdatum (UTC) Moment at which the database definition was created.
DATABASE_NAME varchar2(240) Database Naam van de database.
DESCRIPTION varchar2(1000) Description Description of the database.
DUMMY char Dummy Dummy column.
FORCE_NATIVE boolean Forceer Native Whether to force a native connection instead of using Invantive SQL.
FULL_NAME varchar2(240) Volledige Naam Full name of the database.
GROUP_NAME varchar2(240) Groepsnaam Name of the database group.
HAS_DATA_CACHE_CONNECTION_STRING boolean Heeft Data Cache-Connectionstring Whether the database uses Data Cache or Data Replicator.
HAS_DATA_DICTIONARY_CONNECTION_STRING boolean Heeft Data Dictionary-Connectionstring Whether the database uses a connection string to store persistent elements of the Data Dictionary.
ID guid ID Unique ID.
IS_DISTRIBUTED boolean Is Gedistribueerd Whether the database is distributed.
IS_STARRED boolean Is Favoriet Whether the database definition is starred as a favorite.
LAST_AUTHENTICATION_TIME_UTC datetime Laatste Authenticatietijd Moment at which the authentication completed last.
MANUALLY_ADAPTED boolean Handmatig Aangepast Whether the database definition was manually adapted.
REGISTRATION_MOMENT_UTC datetime Registratiemoment Moment at which the database was registered in the working memory.
REMOTE_AUTHENTICATION_MODE varchar2(30) Verificatiemodus op Afstand Remote mode to authenticate using.
REQUIRES_INVANTIVE_SQL boolean Vereist Invantive UniversalSQL Whether the database requires use of Invantive SQL.
SETTINGS_FILE_LAST_MODIFIED_UTC datetime Instellingenbestand Laatst Gewijzigd Moment at which the settings file was last modified.
SETTINGS_FILE_NAME_PATH varchar2(240) Instellingen Bestandsnaampad Name and path of the settings.xml file.
SHORT_DESCRIPTION varchar2(240) Korte Omschrijving Short description of the database.
SORTING_ORDER int32 Sorteervolgorde Sorting order of the database within the group.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: