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.

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:

Type	Description

Table	The object is a table
View	The object is a view
Procedure	The object is a procedure
Function	The object is a function

Related DDL Statements

Statement

Description

CREATE TABLE	Creates a new table
CREATE TRIGGER	Creates a new trigger
CREATE INDEX	Creates a new index
CREATE VIEW	Creates a new view
CREATE PROCEDURE	Creates a new procedure
CREATE FUNCTION	Creates a new function
ALTER TABLE	Alters an existing table
ALTER TRIGGER	Alters an existing trigger
ALTER INDEX	Alters an existing index
ALTER VIEW	Alters an existing view
ALTER PROCEDURE	Alters an existing procedure
ALTER FUNCTION	Alters an existing function
DROP TABLE	Drops an existing table
DROP TRIGGER	Drops an existing trigger
DROP INDEX	Drops an existing index
DROP VIEW	Drops an existing view
DROP PROCEDURE	Drops an existing procedure
DROP FUNCTION	Drops an existing function

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap