Icon SchemaDifference Table

Structure
CREATE TABLE "SchemaDifference"
(
"ParentName" VARCHAR(40) COLLATE "ANSI_CI",
"ParentType" VARCHAR(15) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"AlterSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "ParentName" ON "SchemaDifference"
("ParentName")

CREATE INDEX "ParentType" ON "SchemaDifference"
("ParentType")

CREATE INDEX "Name" ON "SchemaDifference"
("Name")

CREATE INDEX "Type" ON "SchemaDifference"
("Type")

Description
This table is populated for the source database when the COMPARE DATABASE statement is executed. The contents of the table reflect the minimal difference between the source database and the target database, and are in the proper dependency order. This table can be used to generate a script for altering objects in a database so that they are equivalent to the target databaes, and in a manner that will not generate any dependency errors.

Information This table is re-populated every time the COMPARE DATABASE statement is executed. If an object requires multiple statements for creating, altering, or dropping sub-objects (such as indexes/triggers for tables), then each statement will be separated by a blank line and terminated with the statement terminator character specified in the COMPARE DATABASE statement (or '!', if no statement terminator character is specified).

The ParentType and Type column values are as follows:

TypeDescription
TableThe object is a table
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
ALTER TABLEAlters an existing table
ALTER TRIGGERAlters an existing trigger
ALTER INDEXAlters an existing index
ALTER VIEWAlters an existing view
ALTER PROCEDUREAlters an existing procedure
ALTER FUNCTIONAlters an existing function
DROP TABLEDrops an existing table
DROP TRIGGERDrops an existing trigger
DROP INDEXDrops an existing index
DROP VIEWDrops an existing view
DROP PROCEDUREDrops an existing procedure
DROP FUNCTIONDrops an existing function
Image