SYSVIEWS

Describes the view definitions within the current database.
Column Name Type Length Nullability Contents
TABLEID CHAR 36 false unique identifier for the view (called TABLEID since it is joined with column of that name in SYSTABLES)
VIEWDEFINITION LONG VARCHAR   false text of view definition
CHECKOPTION CHAR 1 false 'N' (check option not supported yet)
COMPILATION SCHEMAID CHAR 36 false id of the schema containing the view
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSCHEMAS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTABLES
SYSTRIGGERS