• Data Warehouse Service

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

DBA_TABLES

DBA_TABLES describes all tables in the database. It is accessible only to users with system administrator rights.

Table 1 DBA_TABLES columns

Name

Type

Description

owner

character varying(64)

Owner of the table

table_name

character varying(64)

Table name

tablespace_name

character varying(64)

Tablespace name

status

character varying(8)

Whether the current record is valid

temporary

character(1)

Whether the table is a temporary table

dropped

character varying

Whether the current record is deleted