sysarticlecolumns-transact-sql.md

title	sysarticlecolumns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-tables
ms.reviewer
ms.suite	sql
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	sysarticlecolumns sysarticlecolumns_TSQL
dev_langs	TSQL
helpviewer_keywords	sysarticlecolumns system table
ms.assetid	55918592-e05d-43b6-843b-7e4d82fa6275
caps.latest.revision	26
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sysarticlecolumns (Transact-SQL)

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

The sysarticlecolumns table contains one row for each table column that is published in a snapshot or transactional publication, and maps each column to its article. This table is stored in the publication database.

Column name	Data type	Description
artid	int	Identifies an article.
colid	smallint	Identifies a column in an article.
is_udt	bit	Indicates whether the column is a user-defined data type (UDT) column. A value of 1 indicates a UDT column.
is_xml	bit	Indicates whether the column is an xml column. A value of 1 indicates an xml column.
is_max	bit	Indicates whether the column is a Large Value data type column, varchar(max), nvarchar(max), and varbinary(max). A value of 1 indicates a Large Value column.

See Also

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