Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


OBJECT_OBJECT_USE


Records objects that have a dependency on another object.

Column name
Data type
Description

OBJECT_SYSID

INTEGER

System identifier for the object.

OBJECT_TYPE

CHAR(20)

One of:
"BASE TABLE"
"VIEW"
"PROCEDURE"
"FUNCTION"
"DOMAIN"
"SEQUENCE"
"CHARACTER SET"
"COLLATION"
"TRANSLATION".

USED_BY_SYSID

INTEGER

The system identifier of the referenced object.

USED_BY_TYPE

CHAR(20)

One of:
"VIEW"
"PROCEDURE"
"FUNCTION"
"DOMAIN"
"TRIGGER"
"CHARACTER SET"
"COLLATION"
"TRANSLATION".

Primary key: OBJECT_SYSID, OBJECT_TYPE, USED_BY_SYSID, USED_BY_TYPE

Secondary index: USED_BY_SYSID, USED_BY_TYPE



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