sysarticlecolumns (System View) (Transact-SQL)


Applies To: SQL Server

The sysarticlecolumns view exposes additional information about columns in published articles. This view is stored in the distribution database.

Column nameData typeDescription
artidintIdentifies an article.
colidintIdentifies a column in an article.
is_udtintIndicates whether the column is a user-defined data type (UDT) column. A value of 1 indicates a UDT column.
is_xmlintIs if the column is an xml column. A value of 1 indicates an xml column.
is_maxintIs 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.

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

Community Additions