Replication Views (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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

Replication Views in the Distribution Database

Replication Views in the Publication Database

Replication Views in the Subscription Database

See Also

Replication Tables (Transact-SQL)