DROP TYPE

Synopsis

Use the DROP TYPE statement to remove an existing user-defined data type.

Syntax

Diagram

DROPTYPEIFEXISTStype_name

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

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

See also