Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

Creating a Database

This chapter describes the SQL statements for creating and managing the database structure. Examples are based on the database listed in The Example Environment.

In addition, Mimer BSQL provides specific commands for listing and describing database objects, see Mimer BSQL.

SQL includes statements for creating and modifying the database structure:

All information describing the database structure is stored in the data dictionary.

Database Modelling

Before the database is defined, it is extremely important to design the database model. Well-functioning and efficient databases cannot be created without a model as the foundation.

Without careful design, much of the flexibility and efficiency inherent in a relational database structure may be lost.

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