.png)
Rename Tables (Database Engine)
You can rename a table in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL.
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. |
In This Topic
-
Before you begin:
-
To rename a table, using:
Limitations and Restrictions
Renaming a table will not automatically rename references to that table. You must manually modify any objects that reference the renamed table. For example, if you rename a table and that table is referenced in a trigger, you must modify the trigger to reflect the new table name. Use sys.sql_expression_dependencies to list dependencies on the table before renaming it.
Security
To rename a table
-
In Object Explorer, right-click the table you want to rename and choose Design from the shortcut menu.
-
From the View menu, choose Properties.
-
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.
To rename a table
-
In Object Explorer, connect to an instance of Database Engine.
-
On the Standard bar, click New Query.
-
The following example renames the SalesTerritory table to SalesTerr in the Sales schema. Copy and paste the following example into the query window and click Execute.
USE AdventureWorks2012; GO EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
For additional examples, see sp_rename (Transact-SQL).
