DROP TYPE

Drop a user-defined type. Apache Cassandra 2.1 and later.

Drop a user-defined type. Cassandra 2.1 and later.

Synopsis

DROP TYPE IF EXISTS type_name

type_name is the name of a user-defined type.

Table 1. Legend
  • Uppercase means literal
  • Lowercase means not literal
  • Italics mean optional
  • The pipe (|) symbol means OR or AND/OR
  • Ellipsis (...) means repeatable

A semicolon that terminates CQL statements is not included in the synopsis.

Description

This statement immediately and irreversibly removes a type. To drop a type, use ALTER TYPE and the DROP keyword as shown in the following example. Attempting to drop a type that does not exist will return an error unless the IF EXISTS option is used. If the option is used, the statement will be a no-op if the type already exists. Dropping a user-defined type that is in use by a table or another type is not allowed.
DROP TYPE version;