| INM V12 Database for Director
||Structure and indexes
Once a V12 Database file is created, modifying its structure is not an easy task. Because V12 Databse files are optimized both for speed and file size, only a limited number of modifications are allowed to an existing database. For example, to add a field to an existing table, you must first create a new table, create all fields and indexes in it including your new field, import all your records to the new table and finally delete the old table.
The methods used to modify an existing V12 Database are:
1. Dump the structure of your initial database (see Viewing the Structure of a Database in the
user manual) and modify the returned database descriptor.
2. Create a new V12 Database file based on the modified descriptor.
3. Import the content of each table to the new V12 Database file (see the section on Importing from V12 Database).
The above steps can be executed either through Lingo handlers, or using the INM V12 Database Editor.