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