• Data Warehouse Service

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

DBA_TAB_COLUMNS

DBA_TAB_COLUMNS stores the columns of tables. Each column of a table in the database has a row in DBA_TAB_COLUMNS. It is accessible only to users with system administrator rights.

Table 1 DBA_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

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