DROP TYPE

Synopsis

The DROP TYPE statement removes an existing user-defined data type.

Syntax

Diagram

Grammar

drop_type ::= DROP TYPE [ IF EXISTS ] type_name;

Where

• type_name is an identifier (possibly qualified with a keyspace name).

Semantics

• An error is raised if the specified type_name does not exist unless IF EXISTS option is used.
• A user-defined type_name cannot be dropped if it is currently used in a table or another type.

Examples

cqlsh:example> CREATE TYPE person(first_name TEXT, last_name TEXT, email TEXT);

cqlsh:example> DROP TYPE person;

See also

CREATE TABLE DROP TYPE Other CQL Statements