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