| title | Replication Views (Transact-SQL) | Microsoft Docs | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||
| ms.date | 03/14/2017 | |||||||||
| ms.prod | sql-server-2016 | |||||||||
| ms.reviewer | ||||||||||
| ms.suite | ||||||||||
| ms.technology |
|
|||||||||
| ms.tgt_pltfrm | ||||||||||
| ms.topic | language-reference | |||||||||
| applies_to |
|
|||||||||
| dev_langs |
|
|||||||||
| helpviewer_keywords |
|
|||||||||
| ms.assetid | 93e5056d-0d93-4a48-ba33-72762eb995d8 | |||||||||
| caps.latest.revision | 14 | |||||||||
| author | BYHAM | |||||||||
| ms.author | rickbyh | |||||||||
| manager | jhubbard |
[!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) |