Renaming a Table

See Also

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

1. In your database diagram, select the table you want to rename.
   
   
2. Right-click the table, and choose Properties from the shortcut menu.
   
   
3. Choose the Tables tab.
   
   
4. In the Table name box, type a new name. Be sure to choose a name that doesn’t duplicate one in the Selected table list.

   To cancel this action, press the ESC key before leaving this field.

5. Click OK.

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.