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.