Informix Error -9647: Cannot drop extended type <extended_type_name>: still in use. </extended_type_name>
Cause and resolution
Cannot drop extended type <extended_type_name>: still in use. </extended_type_name>
The extended type that you are attempting to drop is being referenced by another type or table. Before you drop the extended type, first drop any type or table that refers to the extended type.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9647 fires when an extended type being dropped is still referenced by another type or a table — per the official guidance.
- Another type or a table still referencing the extended type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Drop any type or table that refers to the extended type first, per the official guidance, before dropping the extended type itself.
Examples
N/A
No specific triggering statement is documented; the named extended type varies.
Diagnostic Checks
- Check the system catalog for types or tables referencing the extended type, and drop those dependents first.
Related Errors / Related Topics
- -9630 — "Cannot drop type (type_name): still in use." The same class of in-use error, for opaque types specifically.
- -9640 — "Cannot drop type (type_name): distinct type defined over the type." The same class of in-use error, naming a distinct type as the specific dependent.
The extended type is still referenced by another type or table — drop those dependents first.