Replication Views (Transact-SQL)

Article
12/03/2008

Contain information used by replication in Microsoft SQL Server 2005. These 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)