---
name: "drop_trigger"
section: "7l"
platform: "linux"
package: "postgresql-client"
version: "7.2.1-2woody8"
release: "Debian 3.0 (Woody)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_trigger/7l"
---

# drop\_trigger(7l)

remove a trigger

## NAME

DROP TRIGGER - remove a trigger

## SYNOPSIS

```
DROP TRIGGER name ON table

```

### INPUTS

- *name*

  The name of an existing trigger.

- *table*

  The name of a table.

### OUTPUTS

- **DROP**

  The message returned if the trigger is successfully dropped.

- **ERROR: DropTrigger: there is no trigger** *name* **on relation "***table***"**

  This message occurs if the trigger specified does not exist.

## DESCRIPTION

**DROP TRIGGER** will remove all references to an existing trigger definition. To execute this command the current user must be the owner of the table for which the trigger is defined.

## EXAMPLES

Destroy the if\_dist\_exists trigger on table films:

```
DROP TRIGGER if_dist_exists ON films;

```

## COMPATIBILITY

- **SQL92**

  There is no **DROP TRIGGER** statement in SQL92.

- **SQL99**

  The **DROP TRIGGER** statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command is simply DROP TRIGGER *name*.

## SEE ALSO

**create\_trigger**(l)