Help Center > > Developer Guide> System Catalogs and System Views> System Views> DBA_OBJECTS

DBA_OBJECTS

Updated at: Jul 15, 2020 GMT+08:00

DBA_OBJECTS displays all database objects in the database. It is accessible only to users with system administrator rights.

Table 1 DBA_OBJECTS columns

Name

Type

Description

owner

name

Owner of the object

object_name

name

Object name

object_id

oid

OID of the object

object_type

name

Type of the object

namespace

oid

Namespace containing the object

created

timestamp with time zone

Object creation time

last_ddl_time

timestamp with time zone

The last time when an object was modified.

For details about the value ranges of last_ddl_time and last_ddl_time, see PG_OBJECT.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel