replication-tables-transact-sql.md

title	Replication Tables (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	system tables [SQL Server], replication replication [SQL Server], system tables
ms.assetid	5696ee73-5d7c-4f26-b7ee-6831c9c3edf7
author	stevestein
ms.author	sstein

Replication Tables (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

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- [!INCLUDEssNoVersion] 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)