| title | Replication Views (Transact-SQL) | Microsoft Docs | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||
| ms.date | 03/14/2017 | |||||||||
| ms.prod | sql | |||||||||
| ms.prod_service | database-engine | |||||||||
| ms.reviewer | ||||||||||
| ms.technology | replication | |||||||||
| ms.topic | language-reference | |||||||||
| dev_langs |
|
|||||||||
| helpviewer_keywords |
|
|||||||||
| ms.assetid | 93e5056d-0d93-4a48-ba33-72762eb995d8 | |||||||||
| author | stevestein | |||||||||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
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.
The following is a list of the system views used by replication, grouped by database.
| MSdatatype_mappings (Transact-SQL) | sysdatatypemappings (Transact-SQL) |
| sysmergeextendedarticlesview (Transact-SQL) | sysmergepartitioninfoview (Transact-SQL) |
| systranschemas (Transact-SQL) |
| sysmergeextendedarticlesview (Transact-SQL) | sysmergepartitioninfoview (Transact-SQL) |
| systranschemas (Transact-SQL) |