Export (0) Print
Expand All

sysarticlecolumns (System View) (Transact-SQL)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft