Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TABLES


Records tables and views in the database.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier of the table or view.

TABLE_TYPE

CHAR(20)

One of:
"BASE TABLE"
"VIEW".

TABLE_NOCOLS

INTEGER

Number of columns in table.

TABLE_RECLEN

INTEGER

Record length for table.

TABLE_CARD

BIGINT

Number of records in table.

STATISTIC_GATHERED

TIMESTAMP(2)

Date and time when statistics for the table or view were lasted updated.

IS_LEVEL2_APPROVED

CHAR(3)

One of:
"NO" = The table can not be used with level 2 DB interface.

IS_PERSISTENT

CHAR(3)

One of:
"NO" = The table is a temporary table
"YES" = The table is not temporary.

DATABANK_SYSID

INTEGER

System identifier of the databank in which the table is stored.

Primary key: TABLE_SYSID

Secondary index: DATABANK_SYSID



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