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_ |
boolean |
Toestaan SQL Trace | Whether the database allows SQL trace. | ||
AUTHENTICATION_ |
varchar2 |
Authenticatiemodus | Mode to authenticate using. | ||
COMMENT |
varchar2 |
Comment | Comment of the database. | ||
CREATED_ |
varchar2 |
Gemaakt door | Whom created the database definition. | ||
CREATED_ |
varchar2 |
Aangemaakt op | On what device the database definition was created. | ||
CREATION_ |
datetime |
Aanmaakdatum (UTC) | Moment at which the database definition was created. | ||
DATABASE_ |
varchar2 |
Database | Naam van de database. | ||
DESCRIPTION |
varchar2 |
Description | Description of the database. | ||
DUMMY |
char |
Dummy | Dummy column. | ||
FORCE_ |
boolean |
Forceer Native | Whether to force a native connection instead of using Invantive SQL. | ||
FULL_ |
varchar2 |
Volledige Naam | Full name of the database. | ||
GROUP_ |
varchar2 |
Groepsnaam | Name of the database group. | ||
HAS_ |
boolean |
Heeft Data Cache-Connectionstring | Whether the database uses Data Cache or Data Replicator. | ||
HAS_ |
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_ |
boolean |
Is Gedistribueerd | Whether the database is distributed. | ||
IS_ |
boolean |
Is Favoriet | Whether the database definition is starred as a favorite. | ||
LAST_ |
datetime |
Laatste Authenticatietijd | Moment at which the authentication completed last. | ||
MANUALLY_ |
boolean |
Handmatig Aangepast | Whether the database definition was manually adapted. | ||
REGISTRATION_ |
datetime |
Registratiemoment | Moment at which the database was registered in the working memory. | ||
REMOTE_ |
varchar2 |
Verificatiemodus op Afstand | Remote mode to authenticate using. | ||
REQUIRES_ |
boolean |
Vereist Invantive UniversalSQL | Whether the database requires use of Invantive SQL. | ||
SETTINGS_ |
datetime |
Instellingenbestand Laatst Gewijzigd | Moment at which the settings file was last modified. | ||
SETTINGS_ |
varchar2 |
Instellingen Bestandsnaampad | Name and path of the settings.xml file. | ||
SHORT_ |
varchar2 |
Korte Omschrijving | Short description of the database. | ||
SORTING_ |
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: