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.)