SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-12
SQL 1046
Where 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
Where 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
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).
1046 Referenced and referencing column lists do not match for
constraint constraint-name.
1047 Request failed. Dependent view view-name exists.
1048 The statement currently supports only RESTRICT drop
behavior.