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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance