Removes registration of a trigger.

Removes registration of a trigger.


DROP TRIGGER IF EXISTS trigger_name ON table_name
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.


The DROP TRIGGER statement removes the registration of a trigger created using CREATE TRIGGER. Apache Cassandra 2.1.1 and later supports the IF EXISTS syntax for dropping a trigger. Cassandra checks for the existence of the trigger before dropping it.

The Trigger API is semi-private and subject to change.