Cloudsync System Tables
Page 3 of 4

SYSPUBS

Lists the publications in the database. It contains one row per publication. It appears only at the source database.

Column Name

Type

Length

Nullable

Contents

PUBLICATIONID

CHAR

36

false

Unique identifier for the publication

PUBLICATIONNAME

VARCHAR

128

false

Name of the publication

SCHEMAID

CHAR

36

false

Unique identifier for the schema containing the publication (joins with SYSSCHEMAS)

Indexes

Unique index SYSPUBS_INDEX1 on (PUBLICATIONID)

Unique index SYSPUBS_INDEX2 on (PUBLICATIONNAME, SCHEMAID)