|
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.
ALTER VIEW "SYS"."SYSCATALOG"( creator,
tname,dbspacename,tabletype,ncols,primary_key,"check",
remarks)
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