复制表 (Transact-SQL)

复制系统表支持复制拓扑。 如果将用户数据库配置为发布服务器或订阅服务器,则复制会将系统表添加到数据库中。 从复制拓扑删除用户数据库时,将删除这些表。 有关使用系统表的通用规则,请参阅系统表 (Transact-SQL)

复制表

下面是复制所使用的系统表的列表,列表按数据库分组。

主数据库中的复制表

MSreplication_options (Transact-SQL)

 

msdb 数据库中的复制表

MSagentparameterlist

MSdbms_map

MSdbms

MSreplmonthresholdmetrics

MSdbms_datatype

sysreplicationalerts

MSdbms_datatype_mapping

 

分发数据库中的复制表

MSagent_parameters

MSpublicationthresholds

MSagent_profiles

MSpublisher_databases

MSarticles

MSreplication_objects

MScached_peer_lsns

MSreplication_subscriptions

MSdistpublishers

MSrepl_commands

MSdistribution_agents

MSrepl_errors

MSdistribution_history

MSrepl_originators

MSdistributiondbs

MSrepl_transactions

MSdistributor

MSrepl_version

MSlogreader_agents

MSsnapshot_agents

MSlogreader_history

MSsnapshot_history

MSmerge_agents

MSsubscriber_info

MSmerge_history

MSsubscriber_schedule

MSmerge_sessions

MSsubscriptions

MSmerge_subscriptions

MSsubscription_properties

MSpublication_access

MStracer_history

MSpublications

MStracer_tokens

分发数据库中的这些表可用于从非 SQL Server 发布服务器复制数据。 有关详细信息,请参阅非 SQL Server 发布服务器

IHarticles

IHpublishercolumnindexes

IHcolumns

IHpublishercolumns

IHconstrainttypes

IHpublisherconstraints

IHindextypes

IHpublisherindexes

IHindextypes

IHpublishers

IHpublications

IHpublishertables

IHpublishercolumnconstraints

IHsubscriptions

发布数据库中的复制表

conflict_<架构>_<表>

MSpeer_originatorid_history

MSdynamicsnapshotjobs

MSpeer_topologyrequest

MSdynamicsnapshotviews

MSpeer_topologyresponse

MSmerge_altsyncpartners

MSpeer_request

MSmerge_conflicts_info

MSpeer_response

MSmerge_contents

MSpub_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

订阅数据库中的复制表

MSdynamicsnapshotjobs

MSmerge_settingshistory

MSdynamicsnapshotviews

MSmerge_tombstone

MSmerge_altsyncpartners

MSpeer_lsns (Transact-SQL)

MSmerge_conflicts_info

MSrepl_queuedtraninfo

MSmerge_contents

MSsnapshotdeliveryprogress

MSmerge_current_partition_mappings

MSsubscription_properties

MSmerge_dynamic_snapshots

sysmergearticlecolumns

MSmerge_errorlineage

sysmergearticles

MSmerge_generation_partition_mappings

sysmergepartitioninfo

MSmerge_genhistory

sysmergepublications

MSmerge_identity_range

sysmergeschemaarticles

MSmerge_metadataaction_request

sysmergeschemachange

MSmerge_partition_groups

sysmergesubscriptions

MSmerge_past_partition_mappings

sysmergesubsetfilters

MSmerge_replinfo

systranschemas

请参阅

参考

复制视图 (Transact-SQL)

概念

配置发布和分发

禁用发布和分发