HP Neoview Messages, Руководство пользователя

Страница: 22 / 400

Recovery
Check that
constraint-name
references a unique or primary constraint in the
referenced table.
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.
Effect
The operation fails.
Recovery None.
SQL 1050
1050 Constraint cannot be dropped because it is used as a referenced
object for a foreign key.
Cause You attempted to drop a unique or primary constraint, with dependent referential
constraints, using the RESTRICT option, which does not remove such constraints.
Effect
The drop command fails.
Recovery
If you want to drop the dependent referential constraints, use the CASCADE option
for the DROP CONSTRAINT command.
22 Data Definition Language (DDL) Messages (1000 Through 1999)