Oninit
Talk to an expert →

Informix Error -47100: Column not in this table.

Cause and resolution

Column not in this table.

You cannot create a constraint on a column that does not exist in the table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-47100 fires in the interactive ALTER TABLE menu when a constraint names a column that doesn't exist in the current table — per the official guidance.

  1. The named column not existing in the table, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Specify a column that actually exists in the table, per the official guidance's implication.
Examples
N/A

No specific triggering statement is documented beyond this menu-driven nonexistent-column restriction.

Diagnostic Checks
  1. Check the table's actual columns, and correct the constraint's referenced column.
Related Errors / Related Topics
  • -47095 — "Column not found in referenced table." A related nonexistent-column error, for the referenced (foreign) table rather than the current table.

A constraint named a column that doesn't exist in this table — correct the column name.