Cloudscape System Tables
Page 17 of 17

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)

COMPILATIONSCHEMAID

CHAR

36

false

id of the schema containing the view

Indexes

SYSVIEWS_INDEX1 unique BTREE index on (TABLEID)