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 TABLE AUDIT(
    EMP_ID INT NOT NULL,
    ENTRY_DATE TEXT NOT NULL
); 

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;

Now delete the record from the old table:

See the trigger:

SELECT name FROM sqlite_master
WHERE type = 'trigger'; 

Output:

Next TopicSQLite Drop Trigger

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

SQLite Tutorial

Databases

Table

CRUD Operation

Clauses/Conditions

SQLite Joins

SQLite Date & Time

Aggregate Functions

SQLite Triggers

SQLite Keys

SQLite Import/Export

Connectivity

Interview Questions

SQLite Trigger AFTER DELETE

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler