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