Skip to content

Latest commit

 

History

History
99 lines (76 loc) · 4.9 KB

replication-views-transact-sql.md

File metadata and controls

99 lines (76 loc) · 4.9 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
Replication Views (Transact-SQL)
Replication views contain information that is used by replication in SQL Server. The views enable easier access to data in replication system tables.
WilliamDAssafMSFT
wiassaf
03/14/2017
sql
replication
reference
distribution databases [SQL Server replication], system views
metadata [SQL Server], views
views [SQL Server], replication
replication views [SQL Server]
publications [SQL Server replication], system views
articles [SQL Server replication], system views
replication metadata [SQL Server]
subscriptions [SQL Server replication], system views
system views [SQL Server], replication
TSQL

Replication Views (Transact-SQL)

[!INCLUDE SQL Server]

These views contain information that is used by replication in [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. 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

:::row::: :::column::: MSdatatype_mappings (Transact-SQL) :::column-end::: :::column::: sysdatatypemappings (Transact-SQL) :::column-end::: :::row-end:::

Replication Views in the Distribution Database

:::row::: :::column::: IHextendedArticleView (Transact-SQL)

    [IHextendedSubscriptionView (Transact-SQL)](../../relational-databases/system-views/ihextendedsubscriptionview-transact-sql.md)

    [IHsyscolumns (Transact-SQL)](../../relational-databases/system-views/ihsyscolumns-transact-sql.md)

    [MSdistribution_status (Transact-SQL)](../../relational-databases/system-views/msdistribution-status-transact-sql.md)

    [sysarticlecolumns (System View) (Transact-SQL)](../../relational-databases/system-views/sysarticlecolumns-system-view-transact-sql.md)
:::column-end:::
:::column:::
    [sysarticles (System View) (Transact-SQL)](../../relational-databases/system-views/sysarticles-system-view-transact-sql.md)

    [sysextendedarticlesview (Transact-SQL)](../../relational-databases/system-views/sysextendedarticlesview-transact-sql.md)

    [syspublications (System View) (Transact-SQL)](../../relational-databases/system-views/syspublications-system-view-transact-sql.md)

    [syssubscriptions (System View) (Transact-SQL)](../../relational-databases/system-views/syssubscriptions-system-view-transact-sql.md)
:::column-end:::

:::row-end:::

Replication Views in the Publication Database

:::row::: :::column::: sysmergeextendedarticlesview (Transact-SQL)

    [systranschemas (Transact-SQL)](../../relational-databases/system-views/systranschemas-transact-sql.md)
:::column-end:::
:::column:::
    [sysmergepartitioninfoview (Transact-SQL)](../../relational-databases/system-views/sysmergepartitioninfoview-transact-sql.md)
:::column-end:::

:::row-end:::

Replication Views in the Subscription Database

:::row::: :::column::: sysmergeextendedarticlesview (Transact-SQL)

    [sysmergepartitioninfoview (Transact-SQL)](../../relational-databases/system-views/sysmergepartitioninfoview-transact-sql.md)
:::column-end:::
:::column:::
    [systranschemas (Transact-SQL)](../../relational-databases/system-views/systranschemas-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

Replication Tables (Transact-SQL)