Skip to content

replication-views-transact-sql.md

Latest commit

 

History

History
103 lines (80 loc) · 5.12 KB

replication-views-transact-sql.md

File metadata and controls

103 lines (80 loc) · 5.12 KB
title Replication Views (Transact-SQL) | Microsoft Docs
description Replication views contain information that is used by replication in SQL Server. The views enable easier access to data in replication system tables.
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic reference
dev_langs
TSQL
helpviewer_keywords
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
ms.assetid 93e5056d-0d93-4a48-ba33-72762eb995d8
author stevestein
ms.author sstein

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)