Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Creating Databanks


A databank is the file where a collection of tables is stored. A Mimer SQL database may contain any number of databanks.

Create Databank Statement

The statement for creating a databank has the general form:

 CREATE DATABANK databank-name
    [OF initial-size PAGES]
    [IN 'filename']
    [WITH transaction-control OPTION];
 

Examples

Create a databank called MIMER_BLOBS with the default parameters:
Note: The default parameters are with TRANS option and size 1000 Mimer pages. This databank is created in a file called 'mimer_blobs.dbf'
 CREATE DATABANK mimer_blobs;
Create the MIMER_STORE databank with LOG option, allocate 1200 Mimer pages for it, and store it in a file called 'mimer_store.dbf':
 CREATE DATABANK mimer_store OF 1200 PAGES IN 'mimer_store.dbf'
    WITH LOG OPTION;
 

At this point, the databank is empty.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX