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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » Consolidated views

SYSCAPABILITIES consolidated view Next Page

SYSCATALOG consolidated view

Each row in the SYSCATALOG view describes a system table.

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.

  as select up.user_name,tab.table_name,file.dbspace_name,
    if tab.table_type = 'BASE' then 'TABLE' else tab.table_type
    endif,(select count(*) from SYS.SYSCOLUMN where
      SYSCOLUMN.table_id = tab.table_id),
    if tab.primary_root = 0 then 'N' else 'Y' endif,
    if tab.table_type <> 'VIEW' then tab.view_def endif,
    tab.remarks from
    SYS.SYSTABLE as tab key join
    SYS.SYSFILE as file join
    SYS.SYSUSERPERM as up on up.user_id = tab.creator
See also