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:

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.

  1. 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.

  2. 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.

  3. 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.

Continue from step 3 of the Create New Table Definitions process.