---
title: "Replication Views (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/14/2017"
ms.prod: "sql"
ms.prod_service: "database-engine"
ms.service: ""
ms.component: "system-views"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "replication"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
applies_to: 
  - "SQL Server"
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
caps.latest.revision: 14
author: "stevestein"
ms.author: "sstein"
manager: "craigg"
ms.workload: "Inactive"
---
# Replication Views (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  These views contain information that is used by replication in [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. The views enable easier access to data in [replication system tables](../../relational-databases/system-tables/replication-tables-transact-sql.md). 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](../../relational-databases/system-stored-procedures/replication-stored-procedures-transact-sql.md).  
  
> [!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)](../../relational-databases/system-views/msdatatype-mappings-transact-sql.md)|[sysdatatypemappings (Transact-SQL)](../../relational-databases/system-views/sysdatatypemappings-transact-sql.md)|  
  
### Replication Views in the Distribution Database  
  
|||  
|-|-|  
|[IHextendedArticleView (Transact-SQL)](../../relational-databases/system-views/ihextendedarticleview-transact-sql.md)|[sysarticles (System View) (Transact-SQL)](../../relational-databases/system-views/sysarticles-system-view-transact-sql.md)|  
|[IHextendedSubscriptionView (Transact-SQL)](../../relational-databases/system-views/ihextendedsubscriptionview-transact-sql.md)|[sysextendedarticlesview (Transact-SQL)](../../relational-databases/system-views/sysextendedarticlesview-transact-sql.md)|  
|[IHsyscolumns (Transact-SQL)](../../relational-databases/system-views/ihsyscolumns-transact-sql.md)|[syspublications (System View) (Transact-SQL)](../../relational-databases/system-views/syspublications-system-view-transact-sql.md)|  
|[MSdistribution_status (Transact-SQL)](../../relational-databases/system-views/msdistribution-status-transact-sql.md)|[syssubscriptions (System View) (Transact-SQL)](../../relational-databases/system-views/syssubscriptions-system-view-transact-sql.md)|  
|[sysarticlecolumns (System View) (Transact-SQL)](../../relational-databases/system-views/sysarticlecolumns-system-view-transact-sql.md)||  
  
### Replication Views in the Publication Database  
  
|||  
|-|-|  
|[sysmergeextendedarticlesview (Transact-SQL)](../../relational-databases/system-views/sysmergeextendedarticlesview-transact-sql.md)|[sysmergepartitioninfoview (Transact-SQL)](../../relational-databases/system-views/sysmergepartitioninfoview-transact-sql.md)|  
|[systranschemas (Transact-SQL)](../../relational-databases/system-views/systranschemas-transact-sql.md)||  
  
### Replication Views in the Subscription Database  
  
|||  
|-|-|  
|[sysmergeextendedarticlesview (Transact-SQL)](../../relational-databases/system-views/sysmergeextendedarticlesview-transact-sql.md)|[sysmergepartitioninfoview (Transact-SQL)](../../relational-databases/system-views/sysmergepartitioninfoview-transact-sql.md)|  
|[systranschemas (Transact-SQL)](../../relational-databases/system-views/systranschemas-transact-sql.md)||  
  
## See Also  
 [Replication Tables (Transact-SQL)](../../relational-databases/system-tables/replication-tables-transact-sql.md)