Dropping a row data type

Dropping a row data type is done when the row data type is no longer required or when you want to reuse the name of an existing row data type.

Before you begin

The following prerequisites must be met before you can drop a row data type:
  • A connection to the database must be established.
  • The row data type must exist in the database.

About this task

Dropping a row data type is done when the row data type is no longer required or when you want to reuse the name of an existing row data type. Dropping a row can be done from any interface that supports the execution of the DROP statement.

Procedure

  1. Formulate a DROP statement that specifies the name of the row data type to be dropped.
  2. Execute the DROP statement from a supported Db2® interface.

Example

The following is an example of how to drop a row data type named simpleRow.

DROP TYPE simpleRow;

What to do next

If the DROP statement executes successfully, the row data type is dropped from the database.