Option 5: Regenerate Table
This option allows you to repeat the Create New Table Definitions process for a single existing SQL table and its associated Reality file.
Regenerate table offers the same methods for creating the table definition as Option 1: Create New Table Definitions:
- Automatic conversion of all or selected data/ index definitions to columns/ index definitions.
- Manual selection of data/index definitions.
Note
-
Each newly generated SQL column or index definition will overwrite any existing definition with the same name.
-
You will be prompted to choose whether to retain or delete any user-created definitions that are not overwritten.
The Regenerate Table process is similar to that for Create New Table Definitions.
-
On selecting option 5 from the main menu, you are prompted:
Define Filename to be Processed... Enter Filename :
Enter the name of the Reality file for which you wish to regenerate the SQL table. If you enter
?, a list of files is displayed, from which you can select. See Using the SQLM Menu Options. -
You are then prompted:
Enter name of Table to be Regenerated: Enter Tablename :
Enter the name of the SQL table you wish to regenerate. If you enter
?, a list of tables is displayed, from which you can select. See Using the SQLM Menu Options. -
You are then prompted:
Do you wish to:
A. Update existing Table (keeping untouched entries)
B. Totally replace existing Table
Enter selection (A/B/EXit):- If you enter
A, any user-created definitions that are not overwritten will be retained. - If you enter
B, any user-created definitions that are not overwritten will be deleted. - If you enter
EX, you will be returned to the main menu.
- If you enter
Continue from step 3 of the Create New Table Definitions process.