VIEW_COLUMNS
Provides view attribute information.
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 fromVIEW_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_NAMESPACE |
VARCHAR | For Eon Mode databases, name of the namespace that contains the view. |
TABLE_SCHEMA |
VARCHAR |
The name of this view's schema. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, |
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