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 date and time when the object was created.
object_type_str CHAR (128) Type of object.
 Constraints on underlying system table
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1