Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


OBJECT_COLUMN_USE


Records columns referenced by other database objects.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier for the table.

COLUMN_NAME

VARCHAR(128)

The name of the table column.

USED_BY_SYSID

INTEGER

The system identifier of the referencing object.

USED_BY_TYPE

CHAR(20)

One of:
"VIEW"
"PROCEDURE"
"FUNCTION"
"CHECK"
"TRIGGER".

PRIVILEGE_TYPE

CHAR(20)

One of:
"INSERT"
"DELETE"
"SELECT"
"UPDATE"
"REFERENCES".

Primary key: TABLE_SYSID, COLUMN_NAME, USED_BY_SYSID, USED_BY_TYPE, PRIVILEGE_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