Option 7: Remove Table From SQL Environment

This option allows you to delete an SQL table. Note that the Reality file referenced by the deleted table definition is not deleted, unless it was initially created by the SQL CREATE TABLE command.

To delete an SQL table, proceed as follows:

  1. Select option 7 from the SQLM main menu. You will be prompted:

    Define Tablenames to be Processed....
    Enter Tablename :
  2. Enter the names of the SQL tables you wish to remove. If you enter ?, a list of tables is displayed, from which you can select. See Using the SQLM Menu Options.

    The following prompt is then displayed:

    Selection Completed: Enter <FI>le or <EX>it :
  3. Enter FI  to complete the procedure. If the table definition is removed successfully, a message similar to the following is displayed.

    Processing Selected Tables....
    GUESTS                                  Removed
    Completed: Enter <CR>:

    If you enter EX, the tables are not removed.