msdistributiondbs-transact-sql.md

title	MSdistributiondbs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/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	MSdistributiondbs_TSQL MSdistributiondbs
dev_langs	TSQL
helpviewer_keywords	MSdistributiondbs system table
ms.assetid	d7ffa9df-bf1d-41b8-837e-b762c17c2764
caps.latest.revision	18
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSdistributiondbs (Transact-SQL)

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

The MSdistributiondbs table contains one row for each distribution database defined on the local Distributor. This table is stored in the msdb database.

Column name	Data type	Description
name	sysname	The name of the distribution database.
min_distretention	int	The minimum retention period, in hours, before transactions are deleted.
max_distretention	int	The maximum retention period, in hours, before transactions are deleted.
history_retention	int	The number of hours to retain history.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)