SQLite Trigger After Delete

by Online Tutorials Library July 14, 2022

SQLite Trigger AFTER DELETE

It specifies how to create trigger after delete the data. We have two tables COMPANY and AUDIT.

COMPANY table:

  CREATE TABLE COMPANY(     ID INT PRIMARY KEY     NOT NULL,     NAME           TEXT    NOT NULL,     AGE            INT     NOT NULL,     ADDRESS        CHAR(50),     SALARY         REAL  );  

AUDIT table:

CREATE trigger after delete:

Use the following syntax to create a trigger named “after_del” on COMPANY table after delete operation.

  CREATE TRIGGER after_del  AFTER DELETE    ON COMPANY  BEGIN  INSERT INTO AUDIT(EMP_ID, ENTRY_DATE) VALUES (new.ID, datetime(‘now’));  END;  

Sqlite Trigger after delete 1

Now delete the record from the old table:

Sqlite Trigger after delete 2

See the trigger:

Output:

Sqlite Trigger after delete 3

Next TopicSQLite Drop Trigger

SQLite Trigger After Delete

SQLite Trigger AFTER DELETE

SUM Function in SQL

Event Listener

You may also like