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

sysarticlecolumns (System View) (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 view exposes additional information about columns in published articles. This view is stored in the distribution database.

Column name

Data type

Description

artid

int

Identifies an article.

colid

int

Identifies a column in an article.

is_udt

int

Indicates whether the column is a user-defined data type (UDT) column. A value of 1 indicates a UDT column.

is_xml

int

Is if the column is an xml column. A value of 1 indicates an xml column.

is_max

int

Is if the column is a Large Value data type column (varchar(max), nvarchar(max) or varbinary(max)). A value of 1 indicates a Large Value column.

Community Additions

ADD
Show:
© 2015 Microsoft