The SYSTABLE view is provided for compatibility with older versions of SQL Anywhere that offered a SYSTABLE system table. However, the SYSTABLE system table has been replaced by the ISYSTAB system table, and its corresponding SYSTAB system view, which you should use instead.
Each row of SYSTABLE view describes one table in the database.
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"."SYSTABLE" as select b.table_id, b.file_id, b.count, 0 as first_page, b.commit_action as last_page, COALESCE(ph.root,0) as primary_root, b.creator, 0 as first_ext_page, 0 as last_ext_page, b.table_page_count, b.ext_page_count, b.object_id, b.table_name, case b.table_type when 1 then 'BASE' when 2 then 'MAT VIEW' when 3 then 'GBL TEMP' when 4 then 'LCL TEMP' when 21 then 'VIEW' when 22 then 'JVT' else 'INVALID' end as table_type, v.view_def, r.remarks, b.replicate, p.existing_obj, p.remote_location,'T' as remote_objtype, p.srvid, case b.server_type when 1 then 'SA' when 2 then 'IQ' when 3 then 'OMNI' else 'INVALID' end as server_type, 10 as primary_hash_limit, 0 as page_map_start, s.source, b."encrypted" from SYS.ISYSTAB as b left outer join SYS.ISYSREMARK as r on(b.object_id = r.object_id) left outer join SYS.ISYSSOURCE as s on(b.object_id = s.object_id) left outer join SYS.ISYSVIEW as v on(b.object_id = v.view_object_id) left outer join SYS.ISYSPROXYTAB as p on(b.object_id = p.table_object_id) left outer join(SYS.ISYSIDX as i left outer join SYS.ISYSPHYSIDX as ph on(i.table_id = ph.table_id and i.phys_index_id = ph.phys_index_id)) on(b.table_id = i.table_id and i.index_category = 1 and i.index_id = 0)