This system table describes all of the database objects.
Only users with the SELECT ANY DICTIONARY system privilege 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
|
Unique 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 |
