ADM_TAB_COLUMNS

ADM_TAB_COLUMNS displays columns in tables. Each column in a table of the database has a row in ADM_TAB_COLUMNS. 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 schema.

**Table 1** ADM_TAB_COLUMNS columns
Name	Type	Description
owner	character varying(64)	Table owner
table_name	character varying(64)	Table name
column_name	character varying(64)	Column name
data_type	character varying(128)	Data type of the column
data_length	integer	Length of the column, in bytes
data_precision	integer	Precision of the data type. This parameter is valid for the numeric data type and NULL for other types.
data_scale	integer	Number of decimal places. This parameter is valid for the numeric data type and 0 for other data types.
nullable	bpchar	Whether the column can be empty (n for the primary key constraint and non-null constraint)
column_id	integer	Sequence number of the column when the table is created
avg_col_len	numeric	Average length of a column, in bytes
char_length	numeric	Column length (in the unit of bytes) which is valid only for varchar, nvarchar2, bpchar, and char types.
comments	text	Specifies the comment content.