ALL_OBJECTS displays metadata for all objects in the database.
Columns
| Column | Type | Description |
|---|---|---|
owner | TEXT | Username of the object's owner. |
schema_name | TEXT | Name of the schema that contains the object. |
object_name | TEXT | Name of the object. |
object_type | TEXT | Type of the object. Possible values: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW. |
status | CHARACTER VARYING | Whether the object state is valid. Included for compatibility only. Always set to VALID. |
temporary | TEXT | Whether the object is temporary. Y: temporary object. N: permanent object. |
last_ddl_time | TIMESTAMP WITH TIME ZONE | Timestamp of the last DDL (Data Definition Language) statement executed on the object. |
data_object_id | OID | Object identifier (OID) of data. |
subobject_name | TEXT | Name of the subobject. |
object_id | OID | Object identifier. |