SYSTEM_COLUMNS
Provides table column information for SYSTEM_TABLES.
Provides table column information for SYSTEM_TABLES.
| Column Name | Data Type | Description |
|---|---|---|
TABLE_ID |
INTEGER | A unique numeric ID assigned by the OpenText™ Analytics Database 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 database 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. |