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.
Reality V15.2 Online Documentation (MoTW) Revision 3
Option 7: Remove Table From SQL Environment (SQL) (m691504+remove.htm)
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:
Select option 7 from the SQLM main menu. You will be prompted:
Define Tablenames to be Processed.... Enter Tablename :
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 :
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.