system.publicationarticles

Advantage SQL Engine

Contains one row for each publication article in the database. This view can also be referenced as system.articles.

Field Name

Field Type

Field Size

Description

Name

Character

200

Article name.

Parent

Character

200

The publication this article belongs to.

Ident_Columns

Memo

Variable

This is the semicolon-delimited list of columns that are used to identify the record at the target database.

Filter

Memo

Variable

The replication filter that is used to determine if an updated record should be replicated.

Include_Columns

Memo

Variable

The vertical filter that specifies which columns to replicate.

Exclude_Columns

Memo

Variable

The vertical filter that specifies which columns to exclude from replication.

Update_Merge

Logical

1

Flag that indicates if the article uses SQL MERGE statements when performing UPDATEs at the target.

Insert_Merge

Logical

1

Flag that indicates if the article uses SQL MERGE statements when performing INSERTs at the target.