DROP TYPE

Remove a user-defined type (UDI) that was created with CREATE TYPE.

See CREATE TYPE.

Syntax

DROP TYPE [ IF EXISTS ] [ schema-name. ] SQL92Identifier RESTRICT

The type name consists of an optional schemaName and a SQL92Identifier. If a schemaName is not provided, the current schema is the default schema. If a qualified type name is specified, the schema name cannot begin with SYS.

Include the IF EXISTS clause to execute the statement only if the specified type exists in GemFire XD.

The RESTRICT keyword is required. CASCADE semantics are not supported. That is, GemFire XD will not track down and drop orphaned objects.

Dropping a UDT implicitly drops all USAGE privileges that reference it.

You cannot drop a type if it would make another SQL object unusable. This includes the following restrictions:

Example

DROP TYPE price RESTRICT;