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