Neoview Messages Manual (R2.2)

constraint-name
is the name of a column constraint or table constraint.
Cause The columns that constraint-name references in the referenced table are not part
of a unique constraint.
Effect The operation fails.
Recovery Check that constraint-name references a unique or primary constraint in the
referenced table.
SQL 1045
1045 The unique constraint cannot be used because it is deferrable.
Cause The referential constraint is referencing the unique constraint that is declared as
deferrable. This is an internal error.
Effect The operation fails.
Recovery Check that the referential constraint references a unique constraint that is not
declared deferrable. Contact the GMCSC.
SQL 1046
1046 Referenced and referencing column lists do not match for constraint
constraint-name.
constraint-name
is the name of a column constraint or table constraint.
Cause The list of referencing columns in constraint-name does not match the list of
unique key columns that it is referencing.
Effect The operation fails.
Recovery Check that the constraint-name list of referencing columns matches the list
of referenced columns.
SQL 1047
1047 Request failed. Dependent view view-name exists.
view-name
is the name of the view on the object being dropped.
Cause An object that has a dependent view cannot be dropped unless you use the CASCADE
option on the DROP statement.
Effect The operation fails.
Recovery To drop the object and all its dependent objects, you can either drop each of the
dependent objects using individual DROP statements before dropping the object itself, or use
the CASCADE clause on the DROP statement for the object.
SQL 1048
1048 The statement currently supports only RESTRICT drop behavior.
Cause Drop behavior CASCADE was specified on a DROP statement that supports only
RESTRICT drop behavior.
Effect The operation fails.
Recovery Reissue the DROP statement, specifying RESTRICT or omitting the drop behavior
(which will default to RESTRICT).
SQL 1049
1049 Constraint cannot be dropped because it was specified to be NOT
DROPPABLE.
Cause You attempted to drop a constraint that is NOT DROPPABLE.
26 Data Definition Language (DDL) Messages (1000 Through 1999)