Help Center > > Developer Guide> System Catalogs and System Views> System Views> ALL_TAB_COLUMNS

ALL_TAB_COLUMNS

Updated at:Jul 15, 2020 GMT+08:00

ALL_TAB_COLUMNS displays description information about columns of the tables accessible to the current user.

Table 1 ALL_TAB_COLUMNS columns

Name

Type

Description

owner

character varying(64)

Owner of the table

table_name

character varying(64)

Table name

column_name

character varying(64)

Name of the column

data_type

character varying(128)

Data type of the column

column_id

integer

Column ID generated when the object is created or column is added

data_length

integer

Length of the column in the unit of bytes

avg_col_len

numeric

Average length of a column in the unit of bytes

nullable

bpchar

Whether the column can be empty. For the primary key constraint and non-null constraint, the value is n.

data_precision

integer

Indicates the 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. For other data types, the value of this parameter is 0.

char_length

numeric

Column length in the unit of bytes. This parameter is valid only for the varchar, nvarchar2, bpchar, and char types.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel