Rename (Tables Menu)

The Rename function allows the name of a table to be changed. Upon selection, a dialog is displayed requesting the new table name. Once a new name is entered, pressing the OK button will change the table name. No table structure or data is modified by this operation.

If the table being renamed has triggers or indices, these remain attached to the table after it has been renamed. However, if there are any view definitions or statements executed by triggers that refer to the table being renamed, these are not automatically modified to use the new table name. If this is required, the triggers or view definitions must be dropped and recreated to use the new table name by hand.