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_ |
boolean |
Allows SQL Trace | Whether the database allows SQL trace. | ||
AUTHENTICATION_ |
varchar2 |
Authentication Mode | Mode to authenticate using. | ||
COMMENT |
varchar2 |
Comment | Comment of the database. | ||
CREATED_ |
varchar2 |
Created by | Whom created the database definition. | ||
CREATED_ |
varchar2 |
Created on | On what device the database definition was created. | ||
CREATION_ |
datetime |
Creation Date (UTC) | Moment at which the database definition was created. | ||
DATABASE_ |
varchar2 |
Database | Name of the database. | ||
DESCRIPTION |
varchar2 |
Description | Description of the database. | ||
DUMMY |
char |
Dummy | Dummy column. | ||
FORCE_ |
boolean |
Force Native | Whether to force a native connection instead of using Invantive SQL. | ||
FULL_ |
varchar2 |
Full Name | Full name of the database. | ||
GROUP_ |
varchar2 |
Group Name | Name of the database group. | ||
HAS_ |
boolean |
Has Data Cache Connection String | Whether the database uses Data Cache or Data Replicator. | ||
HAS_ |
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_ |
boolean |
Is Distributed | Whether the database is distributed. | ||
IS_ |
boolean |
Is Starred | Whether the database definition is starred as a favorite. | ||
LAST_ |
datetime |
Last Authentication Time | Moment at which the authentication completed last. | ||
MANUALLY_ |
boolean |
Manually Adapted | Whether the database definition was manually adapted. | ||
REGISTRATION_ |
datetime |
Registration Moment | Moment at which the database was registered in the working memory. | ||
REMOTE_ |
varchar2 |
Remote Authentication Mode | Remote mode to authenticate using. | ||
REQUIRES_ |
boolean |
Requires Invantive UniversalSQL | Whether the database requires use of Invantive SQL. | ||
SETTINGS_ |
datetime |
Settings File Last Modified | Moment at which the settings file was last modified. | ||
SETTINGS_ |
varchar2 |
Settings File Name Path | Name and path of the settings.xml file. | ||
SHORT_ |
varchar2 |
Short Description | Short description of the database. | ||
SORTING_ |
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: