|
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 |
| status | TINYINT | NOT NULL |
| object_type | TINYINT | NOT NULL |
| creation_time | TIMESTAMP | 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:
| Value | Meaning |
|---|---|
| 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 |
creation_time The date and time when the object was created.
PRIMARY KEY (object_id)