Chapter 16. System Objects for Adaptive Server Enterprise

subscribers to a publication.

Columns

 

Column

 

Data type

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

operation

 

VARCHAR(20)

 

A passthrough operation, or piece of a

 

 

 

 

 

 

 

 

 

passthrough operation, entered using sp_-

 

 

 

 

 

 

 

 

 

passthrough or sp_passthrough_piece.

 

 

value

 

VAR-

 

A subscription column value indicating

 

 

 

 

CHAR(255)

 

which users are to receive the operation.

 

 

id

 

INT

 

 

 

A user who is to receive the operation.

 

sr_publication table

 

 

 

 

 

 

 

 

 

Function

Each row describes a SQL Remote publication.

 

Columns

 

 

 

 

 

 

 

 

 

 

 

 

Column

 

 

 

Data type

 

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

publication_id

 

INT

 

 

An identifier for the publication

 

 

publication_-

 

 

 

VAR-

 

 

The name of the publication.

 

 

name

 

 

 

CHAR(128)

 

 

 

 

sr_publisher table

 

 

 

 

 

 

 

 

 

 

 

Function

The row holds the user ID of the publisher.

 

Columns

 

 

 

 

 

 

 

 

 

 

 

 

Column

 

 

Data type

 

Description

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

user_id

 

 

INT

 

The user ID of the publisher.

 

sr_remoteoption table

 

 

 

 

 

 

 

 

 

Function

Each row describes the values of a SQL Remote message link parameter.

 

Columns

 

 

 

 

 

 

 

 

 

 

 

341

Page 359
Image 359
Sybase DC38133-01-0902-01 manual Srpublication table, Srpublisher table, Srremoteoption table