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(64) | Actual SELECT statement used to create the view |
A composite index on tabid and seqno allows only unique values.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]