DDL commands, Transact-SQL commands, and Adaptive Server system procedures that Replication Server reproduces at the standby database when you enable replication with sp_reptostandby.
An asterisk marks those commands and stored procedures for which replication is supported for Adaptive Server 12.5 and later.
The supported DDL commands are:
alter encryption key
alter key
alter table
create default
create encryption key
create function
create index
create key
create plan*
create procedure
create rule
create schema*
create table
create trigger
create view
drop default
drop encryption key
drop function
drop index
drop procedure
drop rule
drop table
drop trigger
drop view
grant
installjava* – replication of installjava is not supported for MSA environments.
remove java*
revoke
The supported system procedures are:
sp_add_qpgroup*
sp_addalias
sp_addgroup
sp_addmessage
sp_addtype
sp_adduser
sp_bindefault
sp_bindmsg
sp_bindrule
sp_cachestrategy
sp_changegroup
sp_chgattribute
sp_commonkey
sp_config_rep_agent
sp_drop_all_qplans*
sp_drop_qpgroup*
sp_dropalias
sp_dropgroup
sp_dropkey
sp_dropmessage
sp_droptype
sp_dropuser
sp_encryption
sp_export_qpgroup*
sp_foreignkey
sp_hidetext
sp_import_qpgroup*
sp_primarykey
sp_procxmode
sp_recompile
sp_rename
sp_rename_qpgroup*
sp_replication_path
sp_setrepcol
sp_setrepdefmode
sp_setrepproc
sp_setreplicate
sp_setreptable
sp_unbindefault
sp_unbindmsg
sp_unbindrule
The set of DDL commands and system procedures that are supported for replication in the master database is different than the set supported from replication in a user database.