Rename column name in sql server w3schools

Applies to: SQL Server 2016 (13.x) and later versions Azure SQL DatabaseAzure SQL Managed InstanceSQL database in Microsoft Fabric

You can rename a table column in SQL Server by using SQL Server Management Studio or Transact-SQL.

Limitations

Renaming a column doesn't 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.

Renaming a column doesn't automatically update the metadata for any objects which all columns (using ) from that table.

For example, if you rename a table column, and that column is referenced by a non-schema-bound view or function that selects all columns (using ), the metadata for the view or function continues to reflect the original column name.

Refresh the metadata using sp_refreshsqlmodule or sp_refreshview.

Permissions

rename column name in sql server 2014

rename column name in sql server example