DROP ROW TYPE

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

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-DROP ROW TYPE--+-----------+--row_type--RESTRICT------------><
                  '- owner--.-'

Element	Description	Restrictions	Syntax
owner	Name of owner of the ROW type	Must be the owner of row_type	Owner Name
row_type	Name of an existing named ROW data type to be dropped	Must exist. See also the Usage section that follows.	Identifier; Data Type

Usage

The 3DROP ROW TYPE statement removes the entry for the specified row_type from the 3sysxtdtypes system catalog table. You must be the owner of the specified named ROW data type or have the DBA privilege to execute the DROP ROW TYPE statement.

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

Any existing tables or columns are using the named ROW data type.
The named ROW data type is a supertype in an inheritance hierarchy.
A view is defined on a column of the named ROW data type.

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

The DROP ROW TYPE statement cannot drop unnamed ROW data types.