publication Properties, Filter Columns Tab

Replication Wizard Help

Replication Wizard Help

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.

See Also

Column Filters

Filtering Published Data

Schema Changes on Publication Databases