Databases Table

Structure

CREATE TABLE "Databases"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"Path" VARCHAR(255) COLLATE "ANSI_CI",
"InMemory" BOOLEAN,
"EncryptedCatalog" BOOLEAN,
"CatalogCharacterSet" VARCHAR(30) COLLATE "ANSI_CI",
"CatalogVersion" DECIMAL(19,2),
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Databases"
("Name")

Description

This table containes the defined databases in an ElevateDB configuration. Each database in ElevateDB is defined with path information that determines the folder where the database will store its catalog and table files.

The CatalogCharacterSet column represents the character set used by the database, and the values are as follows:

Character Set

Description

ANSI	The module database the ANSI character set
Unicode	The database uses the Unicode character set

The CatalogCharacterSet and CatalogVersion columns are populated by reading the actual database catalog on disk. Please see your product-specific manual for the relevant settings that allow you to turn this feature on or off.

Related DDL Statements

Statement

Description

CREATE DATABASE	Creates a new database
ALTER DATABASE	Alters an existing database
DROP DATABASE	Drops an existing database
RENAME DATABASE	Renames an existing database

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap