publication Properties, Filter Columns Tab
The following options are available on the Filter Columns tab of the publication Properties dialog box.
Options
Owner
View the name of the owner of the table.
Table
View the name of the table on which the article is based.
Article
View the name of the article.
(check box)
Include or exclude a table column from the selected article. Columns that are part of the primary key for the table, as indicated by a key icon in the column, cannot be excluded from the article.
The following columns cannot be excluded from a publication.
Column Type | Type of Publication and Options | Icon |
---|---|---|
Primary key | Transactional publication | Primary key |
Timestamp | Snapshot or transactional publications that allow updatable subscriptions | Clock |
uniqueidentifier | Merge publications | Disabled check box |
msrepl_tran_version | Snapshot or transactional publications that allow updatable subscriptions | Disabled check box |
columns that do not allow NULL and do not have default values | Merge publications
Snapshot or transactional publications that allow updatable subscriptions |
Disabled check box |
Column name
View the name of the column.
Data type (Base Type)
View the data type of the column. If the data type is based on another data type, the base data type is shown in parenthesis.
Add column to table
Allows you to add a column on the publishing table that can then be included in the publication.
Drop selected column
Allows you to drop a column from the publication and from the publishing table.