Explanation
During an SQL ALTER TABLE, you attempted to drop a primary or unique constraint, but it cannot be dropped because there is at least one foreign key reference to it.
The SQLSTATE that equates to this SQL return code is 55S07.
User Response
Remove all foreign key references before dropping the primary or unique constraint. Use a CA Datacom Datadictionary Indented Report or query the SIT tables to locate the foreign key references. For information about querying the SIT, see the CA Datacom/DB Database and System Administration Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|