Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sysarticlecolumns (Transact-SQL)
Collapse the table of content
Expand the table of content

sysarticlecolumns (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft