Informix Error -47095: Column not found in referenced table.
Cause and resolution
Column not found in referenced table.
You cannot create a foreign-key constraint on a column that does not exist in the referenced table. Specify a different referencing or referenced column for the constraint.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47095 fires in the interactive ALTER TABLE menu when a foreign-key constraint names a
column that doesn't exist in the referenced table — per the official guidance.
- The referenced column not existing in the referenced table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Specify a different referencing or referenced column for the constraint, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond this menu-driven foreign-key restriction.
Diagnostic Checks
- Check the referenced table's actual columns, and correct the foreign-key constraint's referenced column.
Related Errors / Related Topics
- -47100 — "Column not in this table." A related nonexistent-column error, for the local table rather than the referenced table.
A foreign-key constraint's referenced column doesn't exist in the referenced table — correct the referenced column.