Show TOC

Supported DDL Commands and System ProceduresLocate this document in the navigation structure

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 login
  • alter login profile
  • alter...modify owner – Replication Server treats tables with different owners as different tables. You must make the relevant change to the table replication definitions if you use alter...modify owner to change the owner for an Adaptive Server replicated table. See Replication Server Administration Guide Volume 1 > Manage RepAgent and Support Adaptive Server > Transfer of Database Object Ownership.

  • alter {precomputed result set | materialized view}

  • alter table

  • create default

  • create encryption key

  • create function

  • create index

  • create key

  • create login
  • create login profile

  • create plan*

  • create {precomputed result set | materialized view}

  • create procedure

  • create rule

  • create schema*

  • create table

  • create trigger

  • create view

  • drop default

  • drop function

  • drop login
  • drop login profile

  • drop index

  • drop {precomputed result set | materialized view}

  • drop procedure

  • drop rule

  • drop table

  • drop trigger

  • drop view

  • grant

  • installjava* – replication of installjava is not supported for MSA environments.

  • refresh {precomputed result set | materialized view}

  • remove java*

  • revoke

  • truncate {precomputed result set | materialized view}

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_restore_system_role

  • sp_setrepcol

  • sp_setrepdefmode

  • sp_setrepproc

  • 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:

  • sp_addexternlogin
  • sp_addlogin
  • sp_addremotelogin
  • sp_addserver
  • sp_defaultdb
  • sp_defaultlanguage
  • sp_displaylevel
  • sp_dropexternlogin
  • sp_droplogin
  • sp_dropremotelogin
  • sp_dropserver
  • sp_locklogin
  • sp_maplogin
  • sp_modifylogin
  • sp_password
  • sp_passwordpolicy – replicated for all options except allow password downgrade.
  • sp_role