---
title: "DROP TRIGGER"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/ddl_drop_trigger/"
---

# DROP TRIGGER

Use the DROP TRIGGER statement to remove a trigger from the database.

## Synopsis

Use the `DROP TRIGGER` statement to remove a trigger from the database.

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
drop_trigger ::= DROP TRIGGER [ IF EXISTS ] name ON table_name 
                 [ CASCADE | RESTRICT ]
```

#### drop\_trigger

DROPTRIGGERIFEXISTS[name](/stable/api/ysql/syntax_resources/grammar_diagrams#name)ON[table\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#table-name)CASCADERESTRICT

## Semantics

- `RESTRICT` is the default and it will throw an error if any objects depend on the trigger.
- `CASCADE` will drop all objects that (transitively) depend on the trigger.

## Examples

```plpgsql
DROP TRIGGER update_moddatetime ON posts;
```

## See also

- [CREATE TRIGGER](/stable/api/ysql/the-sql-language/statements/ddl_create_trigger "CREATE TRIGGER")
- [INSERT](/stable/api/ysql/the-sql-language/statements/dml_insert "INSERT")
- [UPDATE](/stable/api/ysql/the-sql-language/statements/dml_update/ "UPDATE")
- [DELETE](/stable/api/ysql/the-sql-language/statements/dml_delete/ "DELETE")