Icon Dependencies Table

Structure
CREATE TABLE "Dependencies"
(
"ParentName" VARCHAR(40) COLLATE "ANSI_CI",
"ParentType" VARCHAR(15) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"DependentParentName" VARCHAR(40) COLLATE "ANSI_CI",
"DependentParentType" VARCHAR(15) COLLATE "ANSI_CI",
"DependentName" VARCHAR(40) COLLATE "ANSI_CI",
"DependentType" VARCHAR(15) COLLATE "ANSI_CI"
)

CREATE INDEX "ParentName" ON "Dependencies"
("ParentName")

CREATE INDEX "ParentType" ON "Dependencies"
("ParentType")

CREATE INDEX "Name" ON "Dependencies"
("Name")

CREATE INDEX "Type" ON "Dependencies"
("Type")

CREATE INDEX "DependentParentName" ON "Dependencies"
("DependentParentName")

CREATE INDEX "DependentParentType" ON "Dependencies"
("DependentParentType")

CREATE INDEX "DependentName" ON "Dependencies"
("DependentName")

CREATE INDEX "DependentType" ON "Dependencies"
("DependentType")

Description
This table contains the dependencies for all objects in an ElevateDB database.

The ParentType, Type, DependentParentType, and DependentType column values are as follows:

TypeDescription
SchemaThe object is a schema
TableThe object is a table
ColumnThe object is a column
ConstraintThe object is a constraint
TriggerThe object is an trigger
IndexThe object is an index
ViewThe object is a view
ProcedureThe object is a procedure
FunctionThe object is a function

Related DDL Statements
StatementDescription
CREATE TABLECreates a new table
CREATE TRIGGERCreates a new trigger
CREATE INDEXCreates a new index
CREATE VIEWCreates a new view
CREATE PROCEDURECreates a new procedure
CREATE FUNCTIONCreates a new function
Image