ADM_TAB_COLS

ADM_TAB_COLS displays information about table and view columns. Each column of each table and view in the database has a row of data in ADM_TAB_COLS. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas. The number of rows displayed in this view is the same as that in the ADM_TAB_COLUMNS view. Only columns are different.

**Table 1** ADM_TAB_COLS columns
Name	Type	Description
owner	character varying(64)	Owner of a table or view.
table_name	character varying(128)	Name of the table or view.
column_name	character varying(128)	Column name.
data_type	character varying(128)	Data type of a column, which can be a user-defined data type.
data_type_mod	character varying(3)	Not supported. Its value is NULL.
data_type_owner	character varying(128)	Owner of the data type of a column.
data_length	numeric	Length of a column, in bytes.
data_precision	numeric	Precision of a data type. This column is valid for the numeric data type and NULL for other data types.
data_scale	numeric	Number of decimal places. This column is valid for the numeric data type and is set to 0 for other data types.
nullable	character varying(1)	Specifies whether a column can be empty (n for a primary key constraint or NOT NULL constraint).
column_id	numeric	Sequence number of a column when a table is created.
default_length	numeric	Length of the default value of a column, in bytes.
data_default	text	Default value of a column.
num_distinct	numeric	Number of different values in a column.
low_value	raw	Minimum value in a column.
high_value	raw	Maximum value in a column.
density	numeric	Column density.
num_nulls	numeric	Number of empty values in a column.
num_buckets	numeric	Number of buckets in the histogram of a column.
last_analyzed	timestamp(0) without time zone	Last analysis date.
sample_size	numeric	Sample size used to analyze a column.
character_set_name	character varying(44)	Not supported. Its value is NULL.
char_col_decl_length	numeric	Declaration length of a column of the character type.
global_stats	character varying(3)	Not supported. Its value is NO.
user_stats	character varying(3)	Not supported. Its value is NO.
avg_col_len	numeric	Average length of a column, in bytes.
char_length	numeric	Column length (in bytes) which is valid only for the varchar, nvarchar2, bpchar, and char types.
char_used	character varying(1)	Not supported. Set it to B if the data type is varchar, nvarchar2, bpchar, or char, and to NULL for other data types.
v80_fmt_image	character varying(3)	Not supported. Its value is NULL.
data_upgraded	character varying(3)	Not supported. Its value is YES.
hidden_column	character varying(3)	Not supported. Its value is NULL.
virtual_column	character varying	Specifies whether a column is a virtual column (a generated column). YES NO
segment_column_id	numeric	Not supported. Its value is NULL.
internal_column_id	numeric	Internal sequence number of a column. The value is the same as that of COLUMN_ID.
histogram	character varying(15)	Specifies whether the histogram exists and the type of the histogram. NONE: no histogram. FREQUENCY: frequency histogram. EQUI_WIDTH: equal-width histogram.
qualified_col_name	character varying(64)	Qualified column name, which is the same as COLUMN_NAME.
user_generated	character varying(3)	Not supported. Its value is YES.
default_on_null	character varying(3)	Not supported. Its value is NULL.
identity_column	character varying(3)	Not supported. Its value is NULL.
sensitive_column	character varying(3)	Not supported. Its value is NULL.
evaluation_edition	character varying(128)	Not supported. Its value is NULL.
unusable_before	character varying(128)	Not supported. Its value is NULL.
unusable_beginning	character varying(128)	Not supported. Its value is NULL.
collation	character varying(100)	Collation rule of a column. This column conflicts with reserved keywords. Therefore, add the view name when calling this column.
collated_column_id	numeric	Not supported. Its value is NULL.
schema	character varying(64)	Name of the namespace to which the column belongs.