Is this possible to create trigger like this with SQL Anywhere 12?
I would like to monitor all changes on procedures and functions. Or maybe there is another solution to this than trigger? Some event?
asked 28 Jul '16, 10:04
You cannot create/add triggers to any of the system tables, so no, you cannot do what you are proposing. This is true in all versions of SQL Anywhere.
One method to do what you want is to do all updates to your procedures and functions by using a procedure and then within that procedure log the update after performing the update to the system catalog.
answered 28 Jul '16, 10:10