Drop a table in a table hierarchy
If a table and its corresponding named row type have no dependencies (they are not a supertable and supertype), you can drop the table and its type. You must drop the table before you can drop the type. For general information about dropping a table, see the DROP TABLE statement in the IBM® Informix® Guide to SQL: Syntax. For information about how to drop a named row type, see Drop named row types.