Each row in the SYSOBJECT system view describes a database object. The underlying system table for this view is ISYSOBJECT.
|Column name||Column type||Column constraint|
|object_id||UNSIGNED BIGINT||NOT NULL|
object_id The internal ID for the object, uniquely identifying it in the database.
status 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 Type of object. Values include:
creation_time The date and time when the object was created.
PRIMARY KEY (object_id)