Option 6: Rename Table
This option allows you to rename an SQL table:
- Only the SQL table will be renamed - the name of associated Reality file is not changed.
- The new table definition will contain all the attributes and content of the original table definition (only the Name of the table will be changed).
- All cross references will be changed to reflect the change of name.
To rename an SQL table, proceed as follows:
-
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. -
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.