Replication Tables (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

A replication topology is supported by replication system tables. When a user database is configured as a Publisher or a Subscriber, replication adds system tables to the database. These tables are removed when a user database is removed from a replication topology. For general rules regarding using system tables, see System Tables (Transact-SQL).

Replication Tables

The following is a list of the system tables used by replication, grouped by database.

Replication Tables in the master Database

MSreplication_options (Transact-SQL)

Replication Tables in the msdb Database

MSagentparameterlist MSdbms_map
MSdbms MSreplmonthresholdmetrics
MSdbms_datatype sysreplicationalerts
MSdbms_datatype_mapping

Replication Tables in the Distribution Database

MSagent_parameters MSpublicationthresholds
MSagent_profiles MSpublisher_databases
MSarticles MSreplication_objects
MScached_peer_lsns MSreplication_subscriptions
MSdistpublishers MSrepl_commands
MSdistribution_agents MSrepl_errors
MSdistribution_history MSrepl_originators
MSdistributiondbs MSrepl_transactions
MSdistributor MSrepl_version
MSlogreader_agents MSsnapshot_agents
MSlogreader_history MSsnapshot_history
MSmerge_agents MSsubscriber_info
MSmerge_history MSsubscriber_schedule
MSmerge_sessions MSsubscriptions
MSmerge_subscriptions MSsubscription_properties
MSpublication_access MStracer_history
MSpublications MStracer_tokens

These tables in the distribution database are used for replicating data from non- SQL Server Publisher. For more information, see Non-SQL Server Publishers.

IHarticles IHpublishercolumnindexes
IHcolumns IHpublishercolumns
IHconstrainttypes IHpublisherconstraints
IHindextypes IHpublisherindexes
IHindextypes IHpublishers
IHpublications IHpublishertables
IHpublishercolumnconstraints IHsubscriptions

Replication Tables in the Publication Database

conflict_<schema>_<table> MSpeer_originatorid_history
MSdynamicsnapshotjobs MSpeer_topologyrequest
MSdynamicsnapshotviews MSpeer_topologyresponse
MSmerge_altsyncpartners MSpeer_request
MSmerge_conflicts_info MSpeer_response
MSmerge_contents MSpub_identity_range
MSmerge_current_partition_mappings sysarticlecolumns
MSmerge_dynamic_snapshots sysarticles
MSmerge_errorlineage sysarticleupdates
MSmerge_generation_partition_mappings sysmergearticlecolumns
MSmerge_genhistory sysmergearticles
MSmerge_identity_range sysmergepartitioninfo
MSmerge_metadataaction_request sysmergepublications
MSmerge_partition_groups sysmergeschemaarticles
MSmerge_past_partition_mappings sysmergeschemachange
MSmerge_replinfo sysmergesubscriptions
MSmerge_settingshistory sysmergesubsetfilters
MSmerge_tombstone syspublications
MSpeer_conflictdetectionconfigrequest sysschemaarticles
MSpeer_conflictdetectionconfigresponse syssubscriptions
MSpeer_lsns systranschemas

Replication Tables in the Subscription Database

MSdynamicsnapshotjobs MSmerge_settingshistory
MSdynamicsnapshotviews MSmerge_tombstone
MSmerge_altsyncpartners MSpeer_lsns (Transact-SQL)
MSmerge_conflicts_info MSrepl_queuedtraninfo
MSmerge_contents MSsnapshotdeliveryprogress
MSmerge_current_partition_mappings MSsubscription_properties
MSmerge_dynamic_snapshots sysmergearticlecolumns
MSmerge_errorlineage sysmergearticles
MSmerge_generation_partition_mappings sysmergepartitioninfo
MSmerge_genhistory sysmergepublications
MSmerge_identity_range sysmergeschemaarticles
MSmerge_metadataaction_request sysmergeschemachange
MSmerge_partition_groups sysmergesubscriptions
MSmerge_past_partition_mappings sysmergesubsetfilters
MSmerge_replinfo systranschemas

See Also

Configure Publishing and Distribution
Disable Publishing and Distribution
Replication Views (Transact-SQL)