SYSOBJECT system view

Each row in the SYSOBJECT system view describes a database object. The underlying system table for this view is ISYSOBJECT.

Column name	Data type	Description
object_id	UNSIGNED BIGINT	The internal ID for the object, uniquely identifying it in the database.
status	TINYINT	The status of the object. Values include: 1 (valid) The object is available for use by the database server. This status is synonymous with ENABLED. That is, if you ENABLE an object, the status changes to VALID. 2 (invalid) An attempt to recompile the object after an internal operation has failed, for example, after a schema-altering modification to an object on which it depends. The database server continues to try to recompile the object whenever it is referenced in a statement. 4 (disabled) The object has been explicitly disabled by the user, for example using an ALTER TABLE...DISABLE VIEW DEPENDENCIES statement.
object_type	TINYINT	Type of object.
creation_time	TIMESTAMP	The local date and time when the object was created.
object_type_str	CHAR (128)	Type of object.
creation_time_utc	TIMESTAMP WITH TIME ZONE	The UTC date and time when the object was created.

Discuss this page in DocCommentXchange.