EXA_ALL_OBJECTS

This system table describes all of the database objects to which the current user has access. All users have access to the table.

Column Name Description
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID ID of the object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object
OBJECT_IS_VIRTUAL States whether this is a virtual object
OBJECT_COMMENT Comment on the object