I would like to know if a trigger / event could be executed when a table is created/altered/dropped etc.
So is it possible or is there some other way of achieving this goal?
asked 26 Sep '13, 09:02
No, SQL Anywhere does not support triggers on DDL operations, only DML.
I can't think of anyway to automatically execute a sequence of SQL statements when a DDL operation is performed, but you can always do it manually (i.e. execute the SQL after each create/alter/drop statement).
answered 26 Sep '13, 09:06
The transaction log contains a record of all DDL, and dbtran.exe can be used to read it.
answered 26 Sep '13, 09:38