When you rename a table, the table name is automatically updated in every database diagram in which the table appears. It is updated in the database when you save the table or diagram.
To rename a table
To cancel this action, press the ESC key before leaving this field.
The table is renamed in the diagram as soon as you exit the Table name box.
Note Because the table name is used to automatically create and name relationships, indexes, and constraints, it is recommended that you make any changes to the name of your table before you create these database objects.