DROP TYPE BODY Statement

The DROP TYPE BODY statement drops the body of an ADT, varray type, or nested table type. When you drop a type body, the type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the type, although you cannot call its member functions.

Topics:

Prerequisites
Syntax
Semantics
Example
Related Topics

Prerequisites

The type body must be in your own schema or you must have the DROP ANY TYPE system privilege.

Syntax

drop_type_body::=

Description of the illustration drop_type_body.gif

Semantics

schema

The name of the schema containing the type. The default is your own schema.

type_name

The name of the type body to be dropped.

Restriction on type_name You can drop a type body only if it has no type or table dependencies.

Example

Dropping an ADT Body: Example This statement removes the ADT body data_typ1. See "ADT Examples" for the example that creates this ADT.

DROP TYPE BODY data_typ1;