SYSTEM_COLUMNS

Provides table column information for SYSTEM_TABLES.

Column Name Data Type Description
TABLE_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog, which identifies the table.

TABLE_SCHEMA

VARCHAR

The schema name for which information is listed.

TABLE_NAME

VARCHAR

The table name for which information is listed.

IS_SYSTEM_TABLE

BOOLEAN

Indicates whether the table is a system table, where t is true and f is false.

COLUMN_ID

VARCHAR

A unique VARCHAR ID, assigned by the Vertica catalog, that identifies a column in a table.

COLUMN_NAME

VARCHAR

The column name for which information is listed in the database.

DATA_TYPE

VARCHAR

The data type assigned to the column; for example VARCHAR(16).

DATA_TYPE_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog, which identifies the data type.

DATA_TYPE_LENGTH

INTEGER

The maximum allowable length of the data type.

CHARACTER_MAXIMUM_LENGTH

INTEGER

The maximum allowable length of the column.

NUMERIC_PRECISION

INTEGER

The number of significant decimal digits.

NUMERIC_SCALE

INTEGER

The 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 respective to other columns in the table.

IS_NULLABLE

BOOLEAN

Indicates whether the column can contain null values, where t is true and f is false.

COLUMN_DEFAULT

VARCHAR

The default value of a column, such as empty or expression.