Skip to content

rename-columns-database-engine.md

Latest commit

 

History

History
86 lines (56 loc) · 3.31 KB

rename-columns-database-engine.md

File metadata and controls

86 lines (56 loc) · 3.31 KB
title Rename Columns (Database Engine) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology table-view-index
ms.topic conceptual
helpviewer_keywords
columns [SQL Server], names
renaming columns
column names [SQL Server]
ms.assetid 7c71ec9f-0180-4398-b32a-4bfb7592e75d
author stevestein
ms.author sstein
manager craigg

Rename Columns (Database Engine)

You can rename a table column in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Limitations and Restrictions

Renaming a column will not automatically rename references to that column. You must modify any objects that reference the renamed column manually. For example, if you rename a table column and that column is referenced in a trigger, you must modify the trigger to reflect the new column name. Use sys.sql_expression_dependencies to list dependencies on the object before renaming it.

Security

Permissions

Requires ALTER permission on the object.

Using SQL Server Management Studio

To rename a column using Object Explorer

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. In Object Explorer, right-click the table in which you want to rename columns and choose Rename.

  3. Type a new column name.

To rename a column using Table Designer

  1. In Object Explorer, right-click the table to which you want to rename columns and choose Design.

  2. Under Column Name, select the name you want to change and type a new one.

  3. On the File menu, click Savetable name.

Note

You can also change the name of a column in the Column Properties tab. Select the column whose name you want to change and type a new value for Name.

Using Transact-SQL

To rename a column

To rename a column

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. The following example renames the column TerritoryID in the table Sales.SalesTerritory to TerrID. Copy and paste the following example into the query window and click Execute.

    USE AdventureWorks2012;  
GO  
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';  
GO

For more information, see sp_rename (Transact-SQL).