sysarticlecolumns (Transact-SQL)

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

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 name Data type Description
artid int Identifies an article.
colid smallint Identifies a column in an article.
is_udt bit Indicates whether the column is a user-defined data type (UDT) column. A value of 1 indicates a UDT column.
is_xml bit Indicates whether the column is an xml column. A value of 1 indicates an xml column.
is_max bit Indicates 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.

See Also

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