This topic has not yet been rated - Rate this topic

Replication Views (Transact-SQL)

SQL Server 2005

SQL Server 2012

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)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Replication Views (Transact-SQL)

Replication Views in the msdb Database

Replication Views in the Distribution Database

Replication Views in the Publication Database

Replication Views in the Subscription Database

Reference

Concepts

Help and Information

Community Additions