• Data Warehouse Service

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

USER_TAB_COLUMNS

USER_TAB_COLUMNS stores the table columns accessible to the current user.

Table 1 USER_TAB_COLUMNS columns

Name

Type

Description

owner

character varying(64)

Owner of the table

table_name

character varying(64)

Name of the table

column_name

character varying(64)

Name of the column

data_type

character varying(128)

Data type of the column

column_id

integer

Sequence number of the column when the table is created

data_length

integer

Length of the column in the unit of bytes

comments

text

Comments