Structure

---

CREATE TABLE "TemporaryViews"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Definition" CLOB COLLATE "ANSI",
"Updateable" BOOLEAN
)

CREATE INDEX "Name" ON "TemporaryViews"
("Name")

Description

---

This table contains the defined temporary views in an ElevateDB database. Temporary views are used to implement derived tables. The temporary view used to implement a derived table is dropped as soon as the SELECT statement containing the derived table is unprepared. Please see the SELECT statement for more information on derived tables.

Related DDL Statements

---