On 07/12/2010, at 11:25 AM, Tom Krehbiel wrote: > I haven't been able to find anything in the documentation that indicates how > to get at the trigger definition.
You can, of course, get the definition of any entity from the SQLite_Master table, such as: select Name, SQL from SQLite_Master where Type = 'trigger' and Tbl_Name = 'My Table'; to get the Name and SQL of all triggers for a particular table (or view). But there's no provided way to parse the trigger definition into its parameters (eg instead of|before|after, update of|update|delete|insert, steps). Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
