Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX