sysarticlecolumns (System View) (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

sp_articlecolumn (Transact-SQL)
sysarticlecolumns (Transact-SQL)