v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

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