The sysviews system catalog table describes each view in the database. Because it stores the SELECT statement that created the view, sysviews can contain multiple rows for each view. It has the following columns.
Column Type Explanation
tabid INTEGER Identifying code of the view
seqno SMALLINT Line number of the SELECT statement
viewtext CHAR(256) Actual SELECT statement used to create the view

A composite index on tabid and seqno allows only unique values.