Replication Views (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

These views contain information that is used by replication in Microsoft SQL Server. The views enable easier access to data in replication system tables. Views are created in a user database when that database is enabled as a publication or subscription database. All replication objects are removed from user databases when the database is removed from a replication topology. The preferred method for accessing replication metadata is by using Replication Stored Procedures.

Important

System views should not be altered directly by any user.

Replication Views

The following is a list of the system views used by replication, grouped by database.

Replication Views in the msdb Database

MSdatatype_mappings (Transact-SQL) sysdatatypemappings (Transact-SQL)

Replication Views in the Distribution Database

IHextendedArticleView (Transact-SQL) sysarticles (System View) (Transact-SQL)
IHextendedSubscriptionView (Transact-SQL) sysextendedarticlesview (Transact-SQL)
IHsyscolumns (Transact-SQL) syspublications (System View) (Transact-SQL)
MSdistribution_status (Transact-SQL) syssubscriptions (System View) (Transact-SQL)
sysarticlecolumns (System View) (Transact-SQL)

Replication Views in the Publication Database

sysmergeextendedarticlesview (Transact-SQL) sysmergepartitioninfoview (Transact-SQL)
systranschemas (Transact-SQL)

Replication Views in the Subscription Database

sysmergeextendedarticlesview (Transact-SQL) sysmergepartitioninfoview (Transact-SQL)
systranschemas (Transact-SQL)

See Also

Replication Tables (Transact-SQL)