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