im trying to add a trigger to every database table in my h2 database but im not sure how to do it.
I can select all the tables in the database but how do i loop through them to apply a trigger to each of them like below? SELECT * FROM INFORMATION_SCHEMA.TABLES and loop through each one and apply a trigger to each CREATE TRIGGER MYTRIGGER AFTER INSERT ON TableName FOR EACH ROW CALL\"test.h2Trigger\" -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
