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

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

MSagent_parameters

MSagent_profiles

MSdistpublishers

MSdistributiondbs

MSdistributor

MSdbms

MSdbms_datatype

MSdbms_datatype_mapping

MSdbms_map

MSreplmonthresholdmetrics

sysreplicationalerts

Replication Tables in the Distribution Database

MSarticles

MScached_peer_lsns

MSdistribution_agents

MSdistribution_history

MSlogreader_agents

MSlogreader_history

MSmerge_agents

MSmerge_articlehistory

MSmerge_history

MSmerge_identity_range_allocations

MSmerge_sessions

MSmerge_subscriptions

MSpublication_access

MSpublications

MSpublicationthresholds

MSpublisher_databases

MSqreader_agents

MSqreader_history

MSrepl_backup_lsns

MSrepl_commands

MSrepl_errors

MSrepl_identity_range

MSrepl_originators

MSrepl_transactions

MSrepl_version

MSreplication_monitordata

MSsnapshot_agents

MSsnapshot_history

MSsubscriber_info

MSsubscriber_schedule

MSsubscriptions

MSsubscription_properties

MSsync_states

MStracer_history

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

IHcolumns

IHconstrainttypes

IHindextypes

IHindextypes

IHpublications

IHpublishercolumnconstraints

IHpublishercolumnindexes

IHpublishercolumns

IHpublisherconstraints

IHpublisherindexes

IHpublishers

IHpublishertables

IHsubscriptions

Replication Tables in the Publication Database

conflict_<schema>_<table>

MSdynamicsnapshotjobs

MSdynamicsnapshotviews

MSmerge_altsyncpartners

MSmerge_conflicts_info

MSmerge_contents

MSmerge_current_partition_mappings

MSmerge_dynamic_snapshots

MSmerge_errorlineage

MSmerge_generation_partition_mappings

MSmerge_genhistory

MSmerge_identity_range

MSmerge_metadataaction_request

MSmerge_partition_groups

MSmerge_past_partition_mappings

MSmerge_replinfo

MSmerge_settingshistory

MSmerge_tombstone

MSpeer_conflictdetectionconfigrequest

MSpeer_conflictdetectionconfigresponse

MSpeer_lsns

MSpeer_originatorid_history

MSpeer_request

MSpeer_response

MSpeer_topologyrequest

MSpeer_topologyresponse

MSpub_identity_range

MSrepl_identity_range

sysarticlecolumns

sysarticles

sysarticleupdates

sysmergearticlecolumns

sysmergearticles

sysmergepartitioninfo

sysmergepublications

sysmergeschemaarticles

sysmergeschemachange

sysmergesubscriptions

sysmergesubsetfilters

syspublications

sysschemaarticles

syssubscriptions

systranschemas

Replication Tables in the Subscription Database

MSdynamicsnapshotjobs

MSdynamicsnapshotviews

MSmerge_altsyncpartners

MSmerge_conflicts_info

MSmerge_contents

MSmerge_current_partition_mappings

MSmerge_dynamic_snapshots

MSmerge_errorlineage

MSmerge_generation_partition_mappings

MSmerge_genhistory

MSmerge_identity_range

MSmerge_metadataaction_request

MSmerge_partition_groups

MSmerge_past_partition_mappings

MSmerge_replinfo

MSmerge_settingshistory

MSmerge_tombstone

MSpeer_lsns

MSredirected_publishers

MSrepl_identity_range

MSrepl_queuedtraninfo

MSreplication_objects

MSreplication_subscriptions

MSsnapshotdeliveryprogress

MSsubscription_properties

sysmergearticles

sysmergepartitioninfo

sysmergepublications

sysmergeschemaarticles

sysmergeschemachange

sysmergesubscriptions

sysmergesubsetfilters

systranschemas

See Also

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