Tabelas de replicação (Transact-SQL)Replication Tables (Transact-SQL)

APLICA-SE A: simSQL Server nãoBanco de Dados SQL do Azure nãoAzure Synapse Analytics (SQL DW) nãoParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Uma topologia de replicação tem suporte das tabelas do sistema de replicação.A replication topology is supported by replication system tables. Quando um banco de dados de usuário é configurado como um Publicador ou um Assinante, a replicação adiciona tabelas de sistema ao banco de dados.When a user database is configured as a Publisher or a Subscriber, replication adds system tables to the database. Essas tabelas são removidas quando um banco de dados de usuário é removido de uma topologia de replicação.These tables are removed when a user database is removed from a replication topology. Para regras gerais sobre o uso de tabelas do sistema, consulte tabelas do sistema ()Transact-SQL .For general rules regarding using system tables, see System Tables (Transact-SQL).

Tabelas de ReplicaçãoReplication Tables

A seguir, uma lista de tabelas de sistema usadas pela replicação, agrupadas por banco de dados.The following is a list of the system tables used by replication, grouped by database.

Tabelas de replicação no banco de dados mestreReplication Tables in the master Database

)(Transact-SQL de MSreplication_optionsMSreplication_options (Transact-SQL)
   

Tabelas de replicação no banco de dados msdbReplication Tables in the msdb Database

MSagentparameterlistMSagentparameterlist MSdbmsMSdbms
MSagent_parametersMSagent_parameters MSdbms_datatypeMSdbms_datatype
MSagent_profilesMSagent_profiles MSdbms_datatype_mappingMSdbms_datatype_mapping
MSdistpublishersMSdistpublishers MSdbms_mapMSdbms_map
MSdistributiondbsMSdistributiondbs MSreplmonthresholdmetricsMSreplmonthresholdmetrics
MSdistributorMSdistributor sysreplicationalertssysreplicationalerts
   

Tabelas de replicação no banco de dados de distribuiçãoReplication Tables in the Distribution Database

MSarticlesMSarticles MSrepl_backup_lsnsMSrepl_backup_lsns
MScached_peer_lsnsMScached_peer_lsns MSrepl_commandsMSrepl_commands
MSdistribution_agentsMSdistribution_agents MSrepl_errorsMSrepl_errors
MSdistribution_historyMSdistribution_history MSrepl_identity_rangeMSrepl_identity_range
MSlogreader_agentsMSlogreader_agents MSrepl_originatorsMSrepl_originators
MSlogreader_historyMSlogreader_history MSrepl_transactionsMSrepl_transactions
MSmerge_agentsMSmerge_agents MSrepl_versionMSrepl_version
MSmerge_articlehistoryMSmerge_articlehistory MSreplication_monitordataMSreplication_monitordata
MSmerge_historyMSmerge_history MSsnapshot_agentsMSsnapshot_agents
MSmerge_identity_range_allocationsMSmerge_identity_range_allocations MSsnapshot_historyMSsnapshot_history
MSmerge_sessionsMSmerge_sessions MSsubscriber_infoMSsubscriber_info
MSmerge_subscriptionsMSmerge_subscriptions MSsubscriber_scheduleMSsubscriber_schedule
MSpublication_accessMSpublication_access MSsubscriptionsMSsubscriptions
MSpublicationsMSpublications MSsubscription_propertiesMSsubscription_properties
MSpublicationthresholdsMSpublicationthresholds MSsync_statesMSsync_states
MSpublisher_databasesMSpublisher_databases MStracer_historyMStracer_history
MSqreader_agentsMSqreader_agents MStracer_tokensMStracer_tokens
MSqreader_historyMSqreader_history
   

Essas tabelas no banco de dados de distribuição são usadas para replicar os dados SQL ServerSQL Server do não publicador.These tables in the distribution database are used for replicating data from non- SQL ServerSQL Server Publisher. Para obter mais informações, consulte Publicadores não SQL Server.For more information, see Non-SQL Server Publishers.

IHarticlesIHarticles IHpublishercolumnindexesIHpublishercolumnindexes
IHcolumnsIHcolumns IHpublishercolumnsIHpublishercolumns
IHconstrainttypesIHconstrainttypes IHpublisherconstraintsIHpublisherconstraints
IHindextypesIHindextypes IHpublisherindexesIHpublisherindexes
IHindextypesIHindextypes IHpublishersIHpublishers
IHpublicationsIHpublications IHpublishertablesIHpublishertables
IHpublishercolumnconstraintsIHpublishercolumnconstraints IHsubscriptionsIHsubscriptions
   

Tabelas de replicação no banco de dados de publicaçãoReplication Tables in the Publication Database

tabela<de><de esquema de conflict>conflict_<schema>_<table> MSpeer_requestMSpeer_request
MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSpeer_responseMSpeer_response
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSpeer_topologyrequestMSpeer_topologyrequest
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSpeer_topologyresponseMSpeer_topologyresponse
MSmerge_conflicts_infoMSmerge_conflicts_info MSpub_identity_rangeMSpub_identity_range
MSmerge_contentsMSmerge_contents MSrepl_identity_rangeMSrepl_identity_range
MSmerge_current_partition_mappingsMSmerge_current_partition_mappings sysarticlecolumnssysarticlecolumns
MSmerge_dynamic_snapshotsMSmerge_dynamic_snapshots sysarticlessysarticles
MSmerge_errorlineageMSmerge_errorlineage sysarticleupdatessysarticleupdates
MSmerge_generation_partition_mappingsMSmerge_generation_partition_mappings sysmergearticlecolumnssysmergearticlecolumns
MSmerge_genhistoryMSmerge_genhistory sysmergearticlessysmergearticles
MSmerge_identity_rangeMSmerge_identity_range sysmergepartitioninfosysmergepartitioninfo
MSmerge_metadataaction_requestMSmerge_metadataaction_request sysmergepublicationssysmergepublications
MSmerge_partition_groupsMSmerge_partition_groups sysmergeschemaarticlessysmergeschemaarticles
MSmerge_past_partition_mappingsMSmerge_past_partition_mappings sysmergeschemachangesysmergeschemachange
MSmerge_replinfoMSmerge_replinfo sysmergesubscriptionssysmergesubscriptions
MSmerge_settingshistoryMSmerge_settingshistory sysmergesubsetfilterssysmergesubsetfilters
MSmerge_tombstoneMSmerge_tombstone syspublicationssyspublications
MSpeer_conflictdetectionconfigrequestMSpeer_conflictdetectionconfigrequest sysschemaarticlessysschemaarticles
MSpeer_conflictdetectionconfigresponseMSpeer_conflictdetectionconfigresponse syssubscriptionssyssubscriptions
MSpeer_lsnsMSpeer_lsns systranschemassystranschemas
MSpeer_originatorid_historyMSpeer_originatorid_history
   

Tabelas de replicação no banco de dados de AssinaturaReplication Tables in the Subscription Database

MSdynamicsnapshotjobsMSdynamicsnapshotjobs MSmerge_tombstoneMSmerge_tombstone
MSdynamicsnapshotviewsMSdynamicsnapshotviews MSpeer_lsnsMSpeer_lsns
MSmerge_altsyncpartnersMSmerge_altsyncpartners MSrepl_identity_rangeMSrepl_identity_range
MSmerge_conflicts_infoMSmerge_conflicts_info MSrepl_queuedtraninfoMSrepl_queuedtraninfo
MSmerge_contentsMSmerge_contents MSreplication_objectsMSreplication_objects
MSmerge_current_partition_mappingsMSmerge_current_partition_mappings MSreplication_subscriptionsMSreplication_subscriptions
MSmerge_dynamic_snapshotsMSmerge_dynamic_snapshots MSsnapshotdeliveryprogressMSsnapshotdeliveryprogress
MSmerge_errorlineageMSmerge_errorlineage MSsubscription_propertiesMSsubscription_properties
MSmerge_generation_partition_mappingsMSmerge_generation_partition_mappings sysmergearticlessysmergearticles
MSmerge_genhistoryMSmerge_genhistory sysmergepartitioninfosysmergepartitioninfo
MSmerge_identity_rangeMSmerge_identity_range sysmergepublicationssysmergepublications
MSmerge_metadataaction_requestMSmerge_metadataaction_request sysmergeschemaarticlessysmergeschemaarticles
MSmerge_partition_groupsMSmerge_partition_groups sysmergeschemachangesysmergeschemachange
MSmerge_past_partition_mappingsMSmerge_past_partition_mappings sysmergesubscriptionssysmergesubscriptions
MSmerge_replinfoMSmerge_replinfo sysmergesubsetfilterssysmergesubsetfilters
MSmerge_settingshistoryMSmerge_settingshistory systranschemassystranschemas
   

Consulte TambémSee Also

Configurar a publicação e a distribuição Configure Publishing and Distribution
Desabilitar a publicação e a distribuição Disable Publishing and Distribution
Exibições de replicação (Transact-SQL)Replication Views (Transact-SQL)