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

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

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

-- Safe to run even if the trigger does not exist
DROP TRIGGER IF EXISTS log_insert;

Drop a Trigger in an Attached Database

DROP TRIGGER IF EXISTS aux.log_insert;

Getting Started

Fundamentals

AI and Agents

CLI Reference

SQL Reference

Changelog

DROP TRIGGER

DROP TRIGGER

Syntax

Description

Clauses

Examples

Drop a Trigger

Drop a Trigger with IF EXISTS

Drop a Trigger in an Attached Database

See Also

​DROP TRIGGER

​Syntax

​Description

​Clauses

​Examples

​Drop a Trigger

​Drop a Trigger with IF EXISTS

​Drop a Trigger in an Attached Database

​See Also

DROP TRIGGER

Syntax

Description

Clauses

Examples

Drop a Trigger

Drop a Trigger with IF EXISTS

Drop a Trigger in an Attached Database

See Also