Reference Manual
   CHAPTER 16. System Views     

SYSCOLUMNS system view

CREATE VIEW SYS.SYSCOLUMNS ( creator, cname, tname,
coltype, nulls, length, syslength,
in_primary_key, "colno", default_value, remarks )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
         WHERE user_id = SYSTABLE.creator ),
      column_name, table_name,
      ( SELECT domain_name FROM SYS.SYSDOMAIN
         WHERE domain_id = SYSCOLUMN.domain_id ),
      nulls, width, scale, pkey, column_id,
      "default", SYSCOLUMN.remarks
FROM SYS.SYSCOLUMN == SYS.SYSTABLE

Presents a readable version of the table SYSCOLUMN. (Note the S at the end of the view name that distinguishes it from the SYSCOLUMN table.)