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	Catalog-assigned VARCHAR value that uniquely identifies a table column.
`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.