The following rules govern DDL operations on multiplex databases:
You can create and populate Adaptive Server Anywhere tables and IQ Temporary tables, but on query servers, the effect of these operations is lost the next time you do a synchronize operation if the query server does not have an IQ Local Store.
If you create objects in the SYSTEM dbspace, they are created in the Catalog Store, an Adaptive Server Anywhere (ASA) store. Anything created in SYSTEM on a query server is lost the next time you synchronize.
Create or drop triggers or events on the write server only.
