| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| NAME |
VARCHAR(18) NOT NULL |
Name of the view. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the view. |
G |
| SEQNO |
SMALLINT NOT NULL |
Sequence number of this row; the first portion of the view is on row one
and successive rows have increasing values of SEQNO. |
G |
| CHECK |
CHAR(1) NOT NULL |
Whether the WITH CHECK OPTION clause was specified in the CREATE
VIEW statement:
N No
C Yes with the cascaded semantic
Y Yes with the local semantic
The value is N if the view has no WHERE clause. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic
machine-readable material (MRM) tape. For all other values, see
Release dependency indicators in topic D.0 |
G |
| TEXT |
VARCHAR(254) NOT NULL |
Text or portion of the text of the CREATE VIEW statement. |
G |
| PATHSCHEMAS |
VARCHAR(254) NOT NULL
WITH DEFAULT |
SQL path at the time the view was defined. The path is used to resolve
unqualified data type and function names used in the view definition. |
G |
| RELCREATED |
CHAR(1) NOT NULL
WITH DEFAULT |
Release of DB2 that was used to create the object:
blank Created prior to Version 7.
K
Created on Version 7 |
G |
| TYPE |
CHAR(1) NOT NULL
WITH DEFAULT 'V' |
Type of table:
F SQL function
V View |
G |
