invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMDATABASES: Data Dictionary Databases

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Databases

Database information.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMDATABASES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ALLOWS_SQL_TRACE boolean Allows SQL Trace Whether the database allows SQL trace.
AUTHENTICATION_MODE varchar2(30) Authentication Mode Mode to authenticate using.
COMMENT varchar2(1000) Comment Comment of the database.
CREATED_BY varchar2(240) Created by Whom created the database definition.
CREATED_ON varchar2(240) Created on On what device the database definition was created.
CREATION_DATE_UTC datetime Creation Date (UTC) Moment at which the database definition was created.
DATABASE_NAME varchar2(240) Database Name of the database.
DESCRIPTION varchar2(1000) Description Description of the database.
DUMMY char Dummy Dummy column.
FORCE_NATIVE boolean Force Native Whether to force a native connection instead of using Invantive SQL.
FULL_NAME varchar2(240) Full Name Full name of the database.
GROUP_NAME varchar2(240) Group Name Name of the database group.
HAS_DATA_CACHE_CONNECTION_STRING boolean Has Data Cache Connection String Whether the database uses Data Cache or Data Replicator.
HAS_DATA_DICTIONARY_CONNECTION_STRING boolean Has Data Dictionary Connection String Whether the database uses a connection string to store persistent elements of the Data Dictionary.
ID guid ID Unique ID.
IS_DISTRIBUTED boolean Is Distributed Whether the database is distributed.
IS_STARRED boolean Is Starred Whether the database definition is starred as a favorite.
LAST_AUTHENTICATION_TIME_UTC datetime Last Authentication Time Moment at which the authentication completed last.
MANUALLY_ADAPTED boolean Manually Adapted Whether the database definition was manually adapted.
REGISTRATION_MOMENT_UTC datetime Registration Moment Moment at which the database was registered in the working memory.
REMOTE_AUTHENTICATION_MODE varchar2(30) Remote Authentication Mode Remote mode to authenticate using.
REQUIRES_INVANTIVE_SQL boolean Requires Invantive UniversalSQL Whether the database requires use of Invantive SQL.
SETTINGS_FILE_LAST_MODIFIED_UTC datetime Settings File Last Modified Moment at which the settings file was last modified.
SETTINGS_FILE_NAME_PATH varchar2(240) Settings File Name Path Name and path of the settings.xml file.
SHORT_DESCRIPTION varchar2(240) Short Description Short description of the database.
SORTING_ORDER int32 Sort Order Sorting order of the database within the group.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: