mspublisher-databases-transact-sql.md

title	MSpublisher_databases (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSpublisher_databases MSpublisher_databases_TSQL
dev_langs	TSQL
helpviewer_keywords	MSpublisher_databases system table
ms.assetid	59b0166e-a64c-46b8-befc-c222fa1ccce2
caps.latest.revision	22
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSpublisher_databases (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

The MSpublisher_databases table contains one row for each Publisher/Publisher database pair serviced by the local Distributor. This table is stored in the distribution database.

Column name	Data type	Description
publisher_id	smallint	The ID of the Publisher.
publisher_db	sysname	The name of the Publisher database.
id	int	The ID of the row.
publisher_engine_edition	int	The edition of the [!INCLUDEssNoVersion] Publisher, which can be one of the following: 10 = Personal Edition 11 = Desktop Engine (MSDE) 20 = Standard 21 = Workgroup 30 = Enterprise (Evaluation) 31 = Developer 40 = Express (Express cannot be a publisher. This value is present for completeness.)

See Also

Replication Tables (Transact-SQL)