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||Column constraint|
|publication_id||UNSIGNED INT||NOT NULL|
|object_id||UNSIGNED BIGINT||NOT NULL|
|creator||UNSIGNED INT||NOT NULL|
|sync_type||UNSIGNED INT||NOT 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:
logscan This is a regular publication that uses the transaction log to upload all relevant data that has changed since the last upload.
scripted upload For this publication, the transaction log is ignored and the upload is defined by the user using stored procedures. Information about the stored procedures is stored in the ISYSSYNCSCRIPT system table.
download only This is a download-only publication; no data is uploaded.
PRIMARY KEY (publication_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (creator) references SYS.ISYSUSER (user_id)