Informix Guide to SQL: Syntax SQL Statements

Use the DROP ROW TYPE statement to remove an existing named-row type from the database.

You must be the owner of the row type or have the DBA privilege to use the DROP ROW TYPE statement.

You cannot drop a named-row type if the row type name is in use. You cannot drop a named-row type when any of the following conditions are true:

• Any existing tables or columns are using the row type.
• The row type is a supertype in an inheritance hierarchy.
• A view is defined on the row type.

To drop a named-row type column from a table, use ALTER TABLE.

The DROP ROW TYPE statement does not drop unnamed-row types.

The RESTRICT keyword is required with the DROP ROW TYPE statement. RESTRICT causes DROP ROW TYPE to fail if dependencies on that named-row type exist.

The DROP ROW TYPE statement fails and returns an error message if:

• the named-row type is used for an existing table or column.

Check the systables and syscolumns system catalog tables to find out whether any tables or types use the named-row type.

• the named-row type is the supertype in an inheritance hierarchy.

Look in the sysinherits system catalog table to see which types have child types.

The following statement drops the row type named employee_t:

DROP ROW TYPE employee_t RESTRICT

Related statement: CREATE ROW TYPE

For a description of the system catalog tables, see the Informix Guide to SQL: Reference.

For a discussion of named-row types, see the Informix Guide to SQL: Tutorial.