I know I have to drop any table from a publication before making any changes (ALTER TABLE ...) to the table if the table is in a publication. Do I also have to drop the table if I change any triggers on that table?
Speaking specifically for the behaviour in SQL Anywhere 12:
Only ALTER TABLE and ALTER PUBLICATION can potentially result in "This operation is only allowed within a synchronization schema change" (SQLCODE -1329). CREATE TRIGGER / ALTER TRIGGER does not.
MobiLink (dbmlsync) will only care about the presence of triggers if the "FireTriggers" or "SendTriggers" extended option has been set. These options are only used for generating the upload stream / applying the download stream and otherwise does not affect the normal SQL Anywhere database server operation (outside of dbmlsync).
answered 11 Jul '12, 11:14