How to: Rename Tables
When you rename a table, the table name is automatically updated in the database when you save the table.
Warning
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.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Working with Settings.
To rename a table
In Server Explorer, right-click the table you want to rename and choose Open Table Definition from the shortcut menu.
The table opens in the Table Definition window of Table Designer.
Right-click the table in the Table Definition window and choose Properties from the shortcut menu.
In the field for the Name value in the Properties window, type a new name for the table.
To cancel this action, press the ESC key before leaving this field.
From the File menu choose Save table name**.**