Supported DDL Commands and System Procedures

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.

If the database is the master database, the supported DDL commands are:

  • alter role

  • create role

  • drop role

  • grant role

  • revoke role

If the database is the master database, the supported system procedures are:

Parent topic: sp_reptostandby