Sybase Adaptive Server Anywhere - SYSCOLUMNS System View

SYSCOLUMNS system view
1058
SYSCOLUMNS system view
CREATE VIEW SYS.SYSCOLUMNS ( creator, cname, tname,
coltype, nulls, length, syslength,
in_primary_key, "colno", default_value, column_kind,
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", column_type, SYSCOLUMN.remarks
FROM SYS.SYSCOLUMN JOIN 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.)