Javatpoint Logo
Javatpoint Logo

SQLite Trigger AFTER DELETE

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

COMPANY table:

AUDIT table:

CREATE trigger after delete:

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

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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA