Structure

---

CREATE TABLE "MigratorParams"
(
"MigratorName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Mode" VARCHAR(15) COLLATE "ANSI_CI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"DefaultValue" VARCHAR(60) COLLATE "ANSI",
"OrdinalPos" INTEGER
)

CREATE INDEX "MigratorName" ON "MigratorParams"
("MigratorName")

CREATE INDEX "Name" ON "MigratorParams"
("Name")

Description

---

The migrator parameters are dynamic in ElevateDB and this table reflects the migrator parameters present in the current migrator. The migrator can be changed or modified using the SET MIGRATOR statement. You can find out more about migrating databases in the Migrating Databases topic.

The Mode column values are as follows:


Related DDL Statements

---