systranschemas-transact-sql.md

title	systranschemas (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	systranschemas systranschemas_TSQL
dev_langs	TSQL
helpviewer_keywords	systranschemas system table
ms.assetid	864c3966-cb61-4f2b-8939-ccda112de853
author	stevestein
ms.author	sstein

systranschemas (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

The systranschemas table is used to track schema changes in articles published in transactional and snapshot publications. This table is stored in both publication and subscription databases.

Column name	Data type	Description
tabid	int	Identifies the table article on which the schema change occurred.
startlsn	binary	LSN value at the start of the schema change.
endlsn	binary	LSN value at the end of the schema change.
typeid	int	Type of schema change.

See Also

Replication Tables (Transact-SQL)