Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Rename Tables (Visual Database Tools)

How to: Rename Tables (Visual Database Tools)

When you rename a table, the table name is automatically updated in the database when you save the table.

Caution noteCaution

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.

To rename a table

  1. In Object Explorer, right-click the table you want to rename and choose Design from the shortcut menu.

    The table opens in the Table Definition window of Table Designer.

  2. From the View menu, choose Properties.

  3. In the field for the Name value in the Properties window, type a new name for the table.

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

  5. From the File menu choose Save table name.

Community Additions

© 2015 Microsoft