> ## Documentation Index
> Fetch the complete documentation index at: https://docs.turso.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP TRIGGER

> Remove a trigger from the database

# DROP TRIGGER

The DROP TRIGGER statement removes a trigger from the database schema. Once dropped, the trigger no longer fires in response to its associated table events.

## Syntax

```sql theme={null}
DROP TRIGGER [IF EXISTS] [schema-name.]trigger-name;
```

## Description

DROP TRIGGER removes the named trigger from the database. The trigger must exist unless the `IF EXISTS` clause is specified.

### Clauses

| Clause | Description |
| - | - |
| `IF EXISTS` | Suppresses the error that would occur if the trigger does not exist. The statement is a no-op when the trigger is not found. |
| `schema-name` | The name of the attached database containing the trigger. When omitted, Turso searches for the trigger in the main database. |
| `trigger-name` | The name of the trigger to remove. |

Dropping a trigger does not affect any data in the table the trigger was associated with. It only removes the trigger definition from the schema.

## Examples

### Drop a Trigger

```sql theme={null}
CREATE TRIGGER log_insert AFTER INSERT ON users
BEGIN
    INSERT INTO audit_log (action, user_id) VALUES ('insert', NEW.id);
END;

-- Remove the trigger
DROP TRIGGER log_insert;
```

### Drop a Trigger with IF EXISTS

```sql theme={null}
-- Safe to run even if the trigger does not exist
DROP TRIGGER IF EXISTS log_insert;
```

### Drop a Trigger in an Attached Database

```sql theme={null}
DROP TRIGGER IF EXISTS aux.log_insert;
```

## See Also

* [CREATE TRIGGER](/sql-reference/statements/create-trigger) for creating triggers
* [CREATE TABLE](/sql-reference/statements/create-table) for table definitions


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.