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