Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the column information of tables and views in all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | Tenant ID. |
| OWNER | varchar(128) | NO | The owner of the table, view, or cluster. |
| TABLE_NAME | varchar(128) | NO | The name of the table, view, or cluster. |
| COLUMN_NAME | varchar(128) | NO | Column name. |
| DATA_TYPE | varchar(128) | NO | Type of the column. |
| DATA_TYPE_MOD | varchar(3) | NO | Default value: NULL. |
| DATA_TYPE_OWNER | varchar(128) | NO | Default value: NULL. |
| DATA_LENGTH | bigint(21) | NO | Length of the column in bytes. |
| DATA_PRECISION | bigint(20) | NO | Decimal precision of the NUMBER data type; binary precision of the FLOAT data type; NULL for all other data types. |
| DATA_SCALE | bigint(20) | NO | Number of digits to the right of the decimal point in the column. |
| NULLABLE | varchar(1) | NO | Indicates whether the column allows NULL values. The value is N if the column has a NOT NULL constraint or if the column is part of a PRIMARY KEY. |
| COLUMN_ID | bigint(20) | NO | Serial number of the column created. |
| DEFAULT_LENGTH | bigint(20) | NO | Length of the default value of the column. |
| DATA_DEFAULT | mediumtext | NO | Default value of the column. |
| NUM_DISTINCT | bigint(20) | NO | Number of distinct values in the column. |
| LOW_VALUE | varchar(128) | NO | Lowest value in the column. |
| HIGH_VALUE | varchar(128) | NO | Highest value in the column. |
| DENSITY | bigint(21) | NO | If a histogram is available for the column, this column displays the selectivity of values that fall within less than 2 histogram bins. It does not represent the selectivity of values that fall within 2 or more histogram bins. If a histogram is not available for the column, the value of this column is 1/ NUM_DISTINCT. |
| NUM_NULLS | bigint(20) | NO | Number of NULL values in the column. |
| NUM_BUCKETS | bigint(20) | NO | Number of buckets in the histogram of the column. |
| LAST_ANALYZED | date | NO | Date when the column was last analyzed. |
| SAMPLE_SIZE | bigint(20) | NO | Sample size used for analyzing the column. |
| CHARACTER_SET_NAME | varchar(44) | NO | Character set name: CHAR_CSNCHAR_CS |
| CHAR_COL_DECL_LENGTH | bigint(0) | NO | Default value: NULL. |
| GLOBAL_STATS | varchar(3) | NO | YES if statistics are collected or incrementally maintained, and NO otherwise. |
| USER_STATS | varchar(3) | NO | Indicates whether statistics are directly entered by users (YES) or not (NO). |
| NOTES | varchar(80) | NO | Additional properties. |
| AVG_COL_LEN | bigint(21) | NO | Average length of the column in bytes. |
| CHAR_LENGTH | bigint(20) | NO | Length of the column in characters. This value applies only to the following data types: CHARVARCHAR2NCHARNVARCHAR2 |
| CHAR_USED | varchar(1) | NO | Indicates whether the column uses BYTE length semantics (B) or CHAR length semantics (C), or whether the data type is not any of the following (NULL): CHARVARCHAR2NCHARNVARCHAR2 |
| V80_FMT_IMAGE | varchar(3) | NO | Default value: NULL. |
| DATA_UPGRADED | varchar(3) | NO | Default value: NULL. |
| HIDDEN_COLUMN | varchar(3) | NO | Indicates whether the column is a hidden column (YES) or not (NO). |
| VIRTUAL_COLUMN | varchar(3) | NO | Indicates whether the column is a virtual column (YES) or not (NO). |
| SEGMENT_COLUMN_ID | bigint(0) | NO | Default value: NULL. |
| INTERNAL_COLUMN_ID | bigint(0) | NO | Default value: NULL. |
| HISTOGRAM | varchar(15) | NO | Indicates the presence or type of the histogram: NONEFREQUENCYTOP-FREQUENCYHEIGHT BALANCEDHYBRID |
| QUALIFIED_COL_NAME | text | NO | Qualified column name. |
| USER_GENERATED | varchar(3) | NO | The generation attribute of the column. Options:
NoteFor OceanBase Database V4.3.5, this column takes effect starting from V4.3.5 BP1. |
| DEFAULT_ON_NULL | varchar(3) | NO | Default value: NULL. |
| IDENTITY_COLUMN | varchar(3) | NO | Default value: NULL. |
| EVALUATION_EDITION | varchar(128) | NO | Default value: NULL. |
| UNUSABLE_BEFORE | varchar(128) | NO | Default value: NULL. |
| UNUSABLE_BEGINNING | varchar(128) | NO | Default value: NULL. |
| COLLATION | varchar(100) | NO | Default value: NULL. |
| COLLATED_COLUMN_ID | bigint(0) | NO | Default value: NULL. |