Informix Error -47101: To drop an existing constraint, the current field must be constraint name.
Cause and resolution
To drop an existing constraint, the current field must be constraint name.
The cursor is in the wrong field on the screen. Move the cursor to highlight an entry in the Constraint Name field to drop all columns that are associated with a primary key, check, or unique constraint. Highlight the Constraint field to drop all columns that are associated with a foreign-key constraint.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47101 fires in the interactive ALTER TABLE menu when the cursor is in the wrong field
when trying to drop a constraint — per the official guidance.
- The cursor positioned on the wrong screen field, per the official guidance — the direct, only cause.
Solutions / Resolution
- Highlight an entry in the Constraint Name field to drop all columns associated with a primary key, check, or unique constraint, per the official guidance.
- Highlight the Constraint field to drop all columns associated with a foreign-key constraint, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond this menu-driven cursor-position restriction.
Diagnostic Checks
- Check which screen field the cursor is on, and move it to Constraint Name (primary key/check/unique) or Constraint (foreign key) as appropriate.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -47101 in this set yet.
The cursor was on the wrong field to drop a constraint — move it to Constraint Name or Constraint depending on the constraint type.