TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

sysarticlecolumns (Transact-SQL)

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.

Show:
© 2016 Microsoft