Informix Error -26479: Can not drop ERKEY when table does not have ERKEY
Cause and resolution
Can not drop ERKEY when table does not have ERKEY
You attempted to alter a table to drop the ERKEY when the table did not have the ERKEY attribute.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26479 fires when ALTER TABLE drops ERKEY from a table that doesn't have it — per the
official guidance.
- The table doesn't have the
ERKEYattribute, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't drop
ERKEYfrom a table that doesn't have it, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond dropping a nonexistent ERKEY.
Diagnostic Checks
- Check whether the table has
ERKEY, and skip theALTER TABLE DROPif not.
Related Errors / Related Topics
- -26477 — "Illegal usage of ERKEY" The general
ERKEY-usage restriction this is a specific instance of. - -26478 — "Can not add ERKEY when table already has ERKEY" The mirror-image error,
on adding
ERKEYthat already exists rather than dropping one that doesn't.
ERKEY was dropped from a table that doesn't have it — skip the ALTER TABLE.