Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


EXT_DATABANKS


The EXT_DATABANKS system view shows databanks on which the current ident has table privilege.

An ident with the system privileges BACKUP or SHADOW may see all databanks in the system.

Column name
Data type
Description
DATABANK_
CREATOR
VARCHAR(128)
The name of the authorization ident that created the databank.
DATABANK_NAME
VARCHAR(128)
The name of the databank.
DATABANK_TYPE
VARCHAR(20)
One of:
"LOG"
"TRANS"
"NULL"
"WORK".
IS_MASTER
VARCHAR(3)
One of:
"YES" = the databank is a master databank
"NO" = the databank is not a master databank.
IS_ONLINE
VARCHAR(3)
One of:
"YES" = the databank is online
"NO" = the databank is offline.
FILE_NUMBER
INTEGER
Ordinal number for databank file.
FILE_NAME
VARCHAR(256)
File name for databank.



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