SYSVIEWS

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