OBJECTS
Records objects in the database.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier for the database object. |
OBJECT_TYPE
|
CHAR(20)
|
One of:
"SCHEMA"
"IDENT"
"DATABANK"
"BASE TABLE"
"VIEW"
"INDEX"
"CONSTRAINT"
"DOMAIN"
"MODULE"
"PROCEDURE"
"FUNCTION"
"SEQUENCE"
"TRIGGER"
"CHARACTER SET"
"COLLATION"
"TRANSLATION"
"SHADOW"
"SYNONYM". |
OBJECT_SCHEMA
|
VARCHAR(128)
|
The name of the schema containing the object. |
OBJECT_NAME
|
VARCHAR(128)
|
The name of the object. |
OBJECT_CREATED
|
TIMESTAMP(2)
|
The date and time the object was created. |
OBJECT_ALTERED
|
TIMESTAMP(2)
|
The date and time the object was last altered. |
REMARKS
|
VARCHAR(254)
|
Comments defined on the object. If there is no comment defined the empty string ("") will appear. Remarks relating to columns will be stored in the COLUMNS table. |
Primary key: OBJECT_SYSID
Unique constraint: OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
