The syntax diagram for the CREATE TRIGGER statement can be found here <https://sqlite.org/lang_createtrigger.html>. If you can trace your way through the diagram using your provided statement, then that statement is syntactically correct. That you may have made a spelling or semantic error is **YOUR** problem and not SQLite3's problem. Since the statement sample you have given **IS** indeed valid syntax, the problem is that **YOU** made an error. It is not job of the parser to second-guess your clearly stated syntax free statement on the theory that **YOU** might be an idiot and not know what you are doing. If you wish a product that does hand-holding, then use a product that does hand holding. Microsoft and Apple are the two best known examples of the makers of such nanny products.