Rename a table (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

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 database diagram. You must have the appropriate permission to rename a table. For more information on permissions, see the Microsoft SQL Server documentation.

Caution   Think carefully before you rename a table. If existing queries, views, user-defined functions, stored procedures, or programs refer to that table, the name modification will make these objects invalid.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table you want to rename.
3. Right-click the table, and choose Properties from the shortcut menu.
4. Choose the Tables tab.
5. In the Table name box, type a new name. Be sure to choose a name that does not duplicate one in the Selected table list.
   To cancel this action, press the ESC key before leaving this field.
6. Close the Properties dialog box.

The table is renamed in the database diagram as soon as you exit the Table name box.