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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » Views » Consolidated views

 

SYSPUBLICATIONS consolidated view

Each row in the SYSPUBLICATIONS view describes a SQL Remote or MobiLink publication.

The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.

ALTER VIEW "SYS"."SYSPUBLICATION"
  as select b.publication_id,
    b.object_id,
    b.creator,
    b.publication_name,
    r.remarks,
    b.type,
    b.sync_type
    from SYS.ISYSPUBLICATION as b
      left outer join SYS.ISYSREMARK as r on(b.object_id = r.object_id)
See also