VIEW_COLUMNS
Provides view attribute information.
Note: If you drop a table that is referenced by a view, Vertica does not drop the view. However, attempts to access information about it from VIEW_COLUMNS
return an error that the view is invalid.
Column Name | Data Type | Description |
---|---|---|
TABLE_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog that identifies this view. |
TABLE_SCHEMA
|
VARCHAR |
The name of this view's schema. |
TABLE_NAME
|
VARCHAR |
The view name. |
COLUMN_ID
|
VARCHAR |
A unique VARCHAR ID, assigned by the Vertica catalog, that identifies a column in this view. |
COLUMN_NAME
|
VARCHAR |
The name of a column in this view. |
DATA_TYPE
|
VARCHAR |
The data type of a view column. |
DATA_TYPE_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies a view column's data type. |
DATA_TYPE_LENGTH
|
INTEGER |
The data type's maximum length. |
CHARACTER_MAXIMUM_LENGTH
|
INTEGER |
The column's maximum length, valid only for character types. |
NUMERIC_PRECISION
|
INTEGER |
The column's number of significant decimal digits. |
NUMERIC_SCALE
|
INTEGER |
The column's number of fractional digits. |
DATETIME_PRECISION
|
INTEGER |
For TIMESTAMP data type, returns the declared precision; returns null if no precision was declared. |
INTERVAL_PRECISION
|
INTEGER |
The number of fractional digits retained in the seconds field. |
ORDINAL_POSITION
|
INTEGER |
The position of the column relative to other columns in the view. |
See Also
VIEWS