# 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

Parent topic: Derby System Tables
Related reference
SYSALIASES
SYSCHECKS
SYSCOLPERMS
SYSCOLUMNS
SYSCONGLOMERATES
SYSCONSTRAINTS
SYSDEPENDS
SYSFILES
SYSFOREIGNKEYS
SYSKEYS
SYSROUTINEPERMS
SYSSCHEMAS
SYSSTATISTICS
SYSSTATEMENTS
SYSTABLEPERMS
SYSTABLES
SYSTRIGGERS