• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. ALL_TAB_COLUMNS

ALL_TAB_COLUMNS

ALL_TAB_COLUMNS stores 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