system.subscriptions

Advantage SQL Engine

Contains one row for each subscription in the database.

Field Name

Field Type

Field Size

Description

Name

Character

200

Subscription name.

Publication

Character

200

The publication this subscription is using.

Target

Character

260

The path of the target data dictionary.

Target_UserName

Character

200

The username used by Advantage Database Server when connecting to the target data dictionary.

Replication_Queue

Character

260

The table used to store pending replication updates.

Forward

Logical

1

Flag that indicates if replication updates are forwarded.

Enabled

Logical

1

Flag that indicates if the subscription is enabled.

Comment

Memo

Variable

The description of the subscription.

Options

Integer

4

The options used when creating the subscription. See sp_CreateSubscription.

User_Defined_Prop

Binary

Variable

The user defined property.

Paused

Logical

1

Flag that indicates if the subscription is paused.