I have the same question! After looking up online, it should be something like: CREATE TRIGGER abort_delete_from_my_tbl BEFORE DELETE ON my_tbl BEGIN SELECT RAISE(ABORT, 'You can''t delete records from my_tbl'); END; However, my output runs perfectly, but the way the error is presented in the Expected section of the test cases don't match my output. Expected section shows: Trigger failed as expected due to related po_items: Error: Cannot delete pos record with associated po_items. My section shows: Unexpected sqlite3 error: Error: near line 12: Cannot delete pos record with associated po_items Don't know how to fix that though!