SQL for Reality > Catalog Administration > Option 6: Rename 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 6: Rename Table (SQL) (m691504+rename.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

Option 6: Rename Table

This option allows you to rename an SQL table:

To rename an SQL table, proceed as follows:

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

    Define Tablename to be Processed...
    Enter Tablename :

    Enter the name of the SQL table you wish to rename. If you enter ?, a list of tables is displayed, from which you can select. See Using the SQLM Menu Options.

  2. You will then be prompted:

    Enter alternative Table name for Rename action...
    Enter Tablename :

    Enter the new name for the table. When you press RETURN, the table will be renamed and this will be confirmed by the message:

    SQL table Renamed. Enter <CR>:

    Press RETURN to redisplay the main menu.

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