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, r.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.ISYSPUBLICATION as p join SYS.ISYSUSER as u on u.user_id = p.creator left outer join SYS.ISYSREMARK as r on(p.object_id = r.object_id) |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |