How do I rename a column in a database table using SQL? How do I rename a column in a database table using SQL? database database

How do I rename a column in a database table using SQL?


sql database rename

Specifically for SQL Server, use sp_rename

USE AdventureWorks;GOEXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';GO

sql database rename

On PostgreSQL (and many other RDBMS), you can do it with regular ALTER TABLE statement:

=> SELECT * FROM Test1; id | foo | bar ----+-----+-----  2 |   1 |   2=> ALTER TABLE Test1 RENAME COLUMN foo TO baz;ALTER TABLE=> SELECT * FROM Test1; id | baz | bar ----+-----+-----  2 |   1 |   2

sql database rename

In MySQL, the syntax is ALTER TABLE ... CHANGE:

ALTER TABLE <table_name> CHANGE <column_name> <new_column_name> <data_type> ...

Note that you can't just rename and leave the type and constraints as is; you must retype the data type and constraints after the new name of the column.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last