SQL for Reality > Catalog Administration > Option 5: Regenerate Table

Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

RealityV15.1Online Documentation (MoTW) Revision 7

Option 5: Regenerate Table (SQL) (m691504+regenerate.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

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:

Notes:

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.

RealityV15.1 (MoTW) Revision 7Comment on this topic