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 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