Each row represents a view or materialized query table.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
VIEWSCHEMA | VARCHAR (128) | Schema name of the view or materialized query table. | |
VIEWNAME | VARCHAR (128) | Unqualified name of the view or materialized query table. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the view or materialized query table. | |
OWNERTYPE | CHAR (1) |
|
|
SEQNO | SMALLINT | Always 1. | |
VIEWCHECK | CHAR (1) | Type of view checking.
|
|
READONLY | CHAR (1) |
|
|
VALID | CHAR (1) |
|
|
QUALIFIER | VARCHAR (128) | Value of the default schema at the time of object definition. Used to complete any unqualified references. | |
FUNC_PATH | CLOB (2K) | SQL path in effect when the view or materialized query table was defined. | |
TEXT | CLOB (2M) | Full text of the view or materialized query table CREATE statement, exactly as typed. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the view or materialized query table. | |
Note:
|