# SYSVIEWS system table

The SYSVIEWS table describes the view definitions within the current database.

The following table shows the contents of the SYSVIEWS system table.

Table 1. SYSVIEWS system table
Column Name | Type | Length | Nullable | Contents
--- | --- | --- | --- | ---
TABLEID | CHAR | 36 | false | Unique identifier for the view (join with SYSTABLES.TABLEID)
VIEWDEFINITION | LONG VARCHAR | 32,700 | false | Text of view definition
CHECKOPTION | CHAR | 1 | false | 'N' (check option not supported yet)
COMPILATIONSCHEMAID | CHAR | 36 | true | ID of the schema containing the view

Parent topic: Derby system tables