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.

Constraints on underlying system table

PRIMARY KEY (object_id)
Parent topic: Alphabetical List of System Views