Updated on 2023-10-23 GMT+08:00

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.