• Data Warehouse Service

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

USER_OBJECTS

USER_OBJECTS describes all database objects accessible to the current user.

Table 1 USER_OBJECTS columns

Name

Type

Description

object_name

name

Object name

object_id

oid

OID of the object

object_type

name

Type of the object (TABLEINDEXSEQUENCE, or VIEW)

namespace

oid

Namespace that the object belongs to