Search results
May 27, 2024 · To rename a column of a database in SQL Server, we can use the sp_rename system stored procedure. The sp_rename procedure is a built-in system stored procedure that allows the users to rename various database objects like tables, columns, views, and indexes.
- Overview
- Limitations and restrictions
- Use SQL Server Management Studio
- Use Transact-SQL
- Next steps
- GeneratedCaptionsTabForHeroSec
Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance
You can rename a table column in SQL Server by using SQL Server Management Studio or Transact-SQL.
Renaming a column won'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 SELECT 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.
Rename a column using Object Explorer
1.In Object Explorer, connect to an instance of Database Engine. 2.In Object Explorer, right-click the table in which you want to rename columns and choose Rename. 3.Type a new column name.
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, select Save table name.
Rename a column
The following example renames the column ErrorTime in the table dbo.ErrorLog to ErrorDateTime in the AdventureWorksLT database. Note the output warning, and verify other objects or queries haven't been broken: For more information, see sp_rename (Transact-SQL).
•Modify columns
•sys.sql_expression_dependencies (Transact-SQL)
Learn how to rename a table column in SQL Server by using SQL Server Management Studio or Transact-SQL. See the limitations, permissions, and examples of renaming columns.
Learn how to use the ALTER TABLE statement to add, delete, or modify columns in an existing table. See examples of renaming, dropping, and changing data types of columns in SQL Server, MySQL, and Oracle.
People also ask
How do I rename a table in SQL Server?
How do I rename a column in a table?
How do I rename a column using SP_rename?
How to rename column names in SQL Server using SSMS?
Oct 6, 2008 · You can use the following command to rename the column of any table in SQL Server: exec sp_rename 'TableName.OldColumnName', 'New colunmName'
Learn how to use the sp_rename stored procedure to rename columns, tables, indexes or constraints in SQL Server. See syntax, examples and screenshots of SSMS.
Mar 11, 2024 · Learn two methods to change the column name in a table: using the sp_rename stored procedure or SQL Server Management Studio. See the syntax, examples and screenshots for each method.
Mar 5, 2021 · In SQL Server, you can use the sp_rename stored procedure to rename an object, including a column. Example. Here’s an example to demonstrate: EXEC sp_rename 't1.c1', 'c11'; This renames the column called c1 (in the t1 table) to c11. Including the Object Type. You can also include the object type as a third argument. In this case, we can use COLUMN:
