• Data Warehouse Service

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

USER_TABLES

USER_TABLES stores table information in the current schema.

Table 1 USER_TABLES columns

Name

Type

Description

owner

character varying(64)

Owner of the table

table_name

character varying(64)

Name of the table

tablespace_name

character varying(64)

Name of the tablespace

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