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 Column 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. Values include:
  • 1 - Table
  • 2 - View
  • 3 - Materialized view
  • 4 - Column
  • 5 - Index
  • 6 - Procedure
  • 7 - Trigger
  • 8 - Event
  • 9 - User
  • 10 - Publication
  • 11 - Remote type
  • 12 - Login mapping
  • 13 - JAR
  • 14 - Java class
  • 16 - Service
  • 17 - Text configuration
  • 18 - Dbspace
creation_time TIMESTAMP The date and time when the object was created.
Constraints on underlying system table

PRIMARY KEY (object_id)

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1