Chapter 15 System Tables
1029
SYSPUBLICATION system table
Column name Column type
Column
constraint
Table constraints
publication_id UNSIGNED
INT
NOT NULL Primary key
creator UNSIGNED
INT
NOT NULL Unique index. Foreign
key references
SYSUSERPERM.user_
id
publication_name CHAR(128) NOT NULL Unique index
remarks LONG
VARCHAR
Each row describes a SQL Remote publication.
publication_id A unique identifying number for the publication.
creator The owner of the publication.
publication_name The name of the publication, which must be a valid
identifier.
remarks Descriptive comments.