SQL for Reality > Catalog Administration > Option 7: Remove Table From SQL Environment

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 7: Remove Table From SQL Environment (SQL) (m691504+remove.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

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.

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