Each row in the SYSPUBLICATION system view describes a SQL Remote or MobiLink publication. The underlying system table for this view is ISYSPUBLICATION.
Column name | Column type | Description |
---|---|---|
publication_id | UNSIGNED INT | A number uniquely identifying the publication. |
object_id | UNSIGNED BIGINT | The internal ID for the publication, uniquely identifying it in the database. |
creator | UNSIGNED INT | The owner of the publication. |
publication_name | CHAR(128) | The name of the publication. |
remarks | LONG VARCHAR | Remarks about the publication. This value is stored in the ISYSREMARK system table. |
type | CHAR(1) | This column is deprecated. |
sync_type | UNSIGNED INT | The type of synchronization for the publication. Values include:
|
PRIMARY KEY (publication_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |