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 |