ALL_OBJECTS

ALL_OBJECTS displays all database objects accessible to the current user.

**Table 1** ALL_OBJECTS columns
Column	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	Last time when the object was modified

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

Parent Topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.