Replication Tables (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure 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
MSagent_parameters MSdbms_datatype
MSagent_profiles MSdbms_datatype_mapping
MSdistpublishers MSdbms_map
MSdistributiondbs MSreplmonthresholdmetrics
MSdistributor sysreplicationalerts
   

Replication Tables in the Distribution Database

MSarticles MSrepl_backup_lsns
MScached_peer_lsns MSrepl_commands
MSdistribution_agents MSrepl_errors
MSdistribution_history MSrepl_identity_range
MSlogreader_agents MSrepl_originators
MSlogreader_history MSrepl_transactions
MSmerge_agents MSrepl_version
MSmerge_articlehistory MSreplication_monitordata
MSmerge_history MSsnapshot_agents
MSmerge_identity_range_allocations MSsnapshot_history
MSmerge_sessions MSsubscriber_info
MSmerge_subscriptions MSsubscriber_schedule
MSpublication_access MSsubscriptions
MSpublications MSsubscription_properties
MSpublicationthresholds MSsync_states
MSpublisher_databases MStracer_history
MSqreader_agents MStracer_tokens
MSqreader_history
   

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_request
MSdynamicsnapshotjobs MSpeer_response
MSdynamicsnapshotviews MSpeer_topologyrequest
MSmerge_altsyncpartners MSpeer_topologyresponse
MSmerge_conflicts_info MSpub_identity_range
MSmerge_contents MSrepl_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
MSpeer_originatorid_history
   

Replication Tables in the Subscription Database

MSdynamicsnapshotjobs MSmerge_tombstone
MSdynamicsnapshotviews MSpeer_lsns
MSmerge_altsyncpartners MSrepl_identity_range
MSmerge_conflicts_info MSrepl_queuedtraninfo
MSmerge_contents MSreplication_objects
MSmerge_current_partition_mappings MSreplication_subscriptions
MSmerge_dynamic_snapshots MSsnapshotdeliveryprogress
MSmerge_errorlineage MSsubscription_properties
MSmerge_generation_partition_mappings sysmergearticles
MSmerge_genhistory sysmergepartitioninfo
MSmerge_identity_range sysmergepublications
MSmerge_metadataaction_request sysmergeschemaarticles
MSmerge_partition_groups sysmergeschemachange
MSmerge_past_partition_mappings sysmergesubscriptions
MSmerge_replinfo sysmergesubsetfilters
MSmerge_settingshistory systranschemas
   

See Also

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