Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSPROXYTAB system view Next Page

SYSPUBLICATION system view


Each row in the SYSPUBLICATION system view describes a SQL Remote or MobiLink publication. The underlying system table for this view is ISYSPUBLICATION.

Columns
Column nameColumn typeColumn constraint
publication_id UNSIGNED INT NOT NULL
object_idUNSIGNED BIGINTNOT NULL
creator UNSIGNED INT NOT NULL
publication_name CHAR(128) NOT NULL
remarksLONG VARCHAR
type CHAR(1) NOT NULL
sync_typeUNSIGNED INTNOT NULL

publication_id    A number uniquely identifying the publication.

object_id    The internal ID for the publication, uniquely identifying it in the database.

creator    The owner of the publication.

publication_name    The name of the publication.

remarks    Remarks about the publication. This value is stored in the ISYSREMARK system table.

type    This column is deprecated.

sync_type    The type of synchronization for the publication. Values include:

Constraints on underlying system table

PRIMARY KEY (publication_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL

FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)

See also