Rename History for Tables And Columns


When a table or column is renamed this rename event is tracked in a history. This history is then used to construct rename DDL statements in forward engineer scripts. Without a entry in the history, the script generation algorithm would not know these two tables (or columns) with different names are refering to the same item. It would just script to ADD one and DROP the other.

Viewing the Rename History:

In the View main menu, click Rename History.


Rename Panel

Each Rename Group includes one or more rename events for a give table or column. The forward engineer script generation algorithm will use these rename events to construct a rename DDL statement for that table or column.

Deleting Rename Groups:

Rename Groups can and should be deleted once the new name of a table or column has been forward engineered to all the appropriate database servers.

To delete a rename group, select it in the Rename Groups list and click the Delete Group button.


See also:

Creating Tables
Creating Columns