Skip to content

rename-columns-database-engine.md

Latest commit

 

History

History
80 lines (53 loc) · 3.15 KB

rename-columns-database-engine.md

File metadata and controls

80 lines (53 loc) · 3.15 KB
title Rename Columns (Database Engine) | Microsoft Docs
ms.custom
ms.date 08/03/2017
ms.prod sql
ms.prod_service database-engine, sql-database
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
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Rename Columns (Database Engine)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

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 Save table 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

The following example renames the column TerritoryID in the table Sales.SalesTerritory to TerrID in the AdventureWorks database.

EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';

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