sysarticlecolumns (Transact-SQL)
Collapse the table of content
Expand the table of content

sysarticlecolumns (Transact-SQL)


Applies To: SQL Server

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 nameData typeDescription
artidintIdentifies an article.
colidsmallintIdentifies a column in an article.
is_udtbitIndicates whether the column is a user-defined data type (UDT) column. A value of 1 indicates a UDT column.
is_xmlbitIndicates whether the column is an xml column. A value of 1 indicates an xml column.
is_maxbitIndicates 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.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

© 2016 Microsoft