When you view the properties for an existing subscription, the Create Statement tab shows the SQL statement that is executed at the destination to create the target object.
If the target object is a table the Data Replicator automatically forms the CREATE TABLE statement and you cannot modify it. If the target object is a view, alias, or synonym. you may be able to modify the CREATE statement.
An alias is a qualified name that can be used by any authorization ID. A synonym is an unqualified name that can be used only by the authorization ID that created it.
If the CREATE statement is dynamically prepared on a Db2 destination, users with SYSADMIN authority can create synonyms for other users by changing the value of the CURRENT SQLID special register before the CREATE SYNONYM statement is issued.