Replication Tables (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

Replication Tables (Transact-SQL)

 

Applies To: SQL Server

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).

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

MSagentparameterlistMSdbms_map
MSdbmsMSreplmonthresholdmetrics
MSdbms_datatypesysreplicationalerts
MSdbms_datatype_mapping

Replication Tables in the Distribution Database

MSagent_parametersMSpublicationthresholds
MSagent_profilesMSpublisher_databases
MSarticlesMSreplication_objects
MScached_peer_lsnsMSreplication_subscriptions
MSdistpublishersMSrepl_commands
MSdistribution_agentsMSrepl_errors
MSdistribution_historyMSrepl_originators
MSdistributiondbsMSrepl_transactions
MSdistributorMSrepl_version
MSlogreader_agentsMSsnapshot_agents
MSlogreader_historyMSsnapshot_history
MSmerge_agentsMSsubscriber_info
MSmerge_historyMSsubscriber_schedule
MSmerge_sessionsMSsubscriptions
MSmerge_subscriptionsMSsubscription_properties
MSpublication_accessMStracer_history
MSpublicationsMStracer_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.

IHarticlesIHpublishercolumnindexes
IHcolumnsIHpublishercolumns
IHconstrainttypesIHpublisherconstraints
IHindextypesIHpublisherindexes
IHindextypesIHpublishers
IHpublicationsIHpublishertables
IHpublishercolumnconstraintsIHsubscriptions

Replication Tables in the Publication Database

conflict_<schema>_<table>MSpeer_originatorid_history
MSdynamicsnapshotjobsMSpeer_topologyrequest
MSdynamicsnapshotviewsMSpeer_topologyresponse
MSmerge_altsyncpartnersMSpeer_request
MSmerge_conflicts_infoMSpeer_response
MSmerge_contentsMSpub_identity_range
MSmerge_current_partition_mappingssysarticlecolumns
MSmerge_dynamic_snapshotssysarticles
MSmerge_errorlineagesysarticleupdates
MSmerge_generation_partition_mappingssysmergearticlecolumns
MSmerge_genhistorysysmergearticles
MSmerge_identity_rangesysmergepartitioninfo
MSmerge_metadataaction_requestsysmergepublications
MSmerge_partition_groupssysmergeschemaarticles
MSmerge_past_partition_mappingssysmergeschemachange
MSmerge_replinfosysmergesubscriptions
MSmerge_settingshistorysysmergesubsetfilters
MSmerge_tombstonesyspublications
MSpeer_conflictdetectionconfigrequestsysschemaarticles
MSpeer_conflictdetectionconfigresponsesyssubscriptions
MSpeer_lsnssystranschemas

Replication Tables in the Subscription Database

MSdynamicsnapshotjobsMSmerge_settingshistory
MSdynamicsnapshotviewsMSmerge_tombstone
MSmerge_altsyncpartnersMSpeer_lsns (Transact-SQL)
MSmerge_conflicts_infoMSrepl_queuedtraninfo
MSmerge_contentsMSsnapshotdeliveryprogress
MSmerge_current_partition_mappingsMSsubscription_properties
MSmerge_dynamic_snapshotssysmergearticlecolumns
MSmerge_errorlineagesysmergearticles
MSmerge_generation_partition_mappingssysmergepartitioninfo
MSmerge_genhistorysysmergepublications
MSmerge_identity_rangesysmergeschemaarticles
MSmerge_metadataaction_requestsysmergeschemachange
MSmerge_partition_groupssysmergesubscriptions
MSmerge_past_partition_mappingssysmergesubsetfilters
MSmerge_replinfosystranschemas

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

Community Additions

ADD
Show:
© 2016 Microsoft