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"."SYSPUBLICATIONS" as select u.user_name as creator, p.publication_name, p.remarks, p.type, case p.sync_type when 0 then 'logscan' when 1 then 'scripted upload' when 2 then 'download only' else 'invalid' end as sync_type from SYS.SYSPUBLICATION as p join SYS.SYSUSERPERM as u on u.user_id = p.creator