Replication of Data Definition Language (DDL) commands is supported.
No translation or adjustment of DDL commands is provided
by Replication Agent. DDL commands should therefore only be replicated
to other Microsoft SQL Server databases.
Replication of DDL commands is enabled or disabled in Replication Agent using the pdb_setrepddl command. For details on this command, see the Replication Agent Reference Manual.
If DDL replication is enabled and the pdb_automark_tables parameter
is set to true, the pds_username user
who has the permission to create a table must also have the "ReplicationAdmin"
role.
Replication Server uses the ddl_username parameter to execute DDL commands in the replicate database as the same user who executed the DDL commands in the primary database.
