---
title: "Discussion on \"How to use RAISE and CRUD clauses in the same case trigger in SQLite\" | Hashnode"
description: "Discussion on \"How to use RAISE and CRUD clauses in the same case trigger in SQLite\". I recently had to build a trigger for the return management system for an eCommerce website. Essentially we had two tables: RETURN and RETURN_ITEM.\nI had to make a trigger on insert on RETURN_ITEM, which raises an error and deletes a RETURN entity.\nL..."
url: "https://hashnode.com/posts/how-to-use-raise-and-crud-clauses-in-the-same-case-trigger-in-sqlite/6896fb4f295ef33bb86c688c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to use RAISE and CRUD clauses in the same case trigger in SQLite](https://blogs.affanhamid.com/how-to-use-raise-and-crud-clauses-in-the-same-case-trigger-in-sqlite?utm_source=hashnode&utm_medium=feed)

I recently had to build a trigger for the return management system for an eCommerce website. Essentially we had two tables: RETURN and RETURN\_ITEM. I had to make a trigger on insert on RETURN\_ITEM, which raises an error and deletes a RETURN entity. L...

Nov 12, 2024 · 1 min read · blogs.affanhamid.com  
Read the article

-   [#sqlite](https://hashnode.com/tag/sqlite)
-   [#databases](https://hashnode.com/tag/databases)
-   [#database-programming](https://hashnode.com/tag/database-programming)

## Written by

[Affan Hamid](https://hashnode.com/@affanhamid)

@affanhamid · London, UK

  
[View profile](https://hashnode.com/@affanhamid)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
