How to rename a column name in SQL
By Tan Lee Published on Jul 02, 2024 687
To rename a column in SQL, you typically use the ALTER TABLE statement along with the RENAME COLUMN clause.
Here is the basic syntax how rename the column name in sql.
ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;
For example, suppose you have a table called "Customers" with a column named "FullName". To rename this column to "FirstName", you would use the following SQL statement.
ALTER TABLE Customers RENAME COLUMN FullName TO FirstName
After executing this query, the column previously known as "FullName" will now be called "FirstName".
When you rename a column in SQL, the process affects the table schema but not the actual data stored in the column.
- How to Download ODBC Driver for SQL Server
- How to Download SQL Server Management Studio (SSMS) Versions
- How to Query JSON in SQL Server
- How to modify JSON in SQL Server
- How to set time to 00:00:00 with GETDATE() in SQL
- How to find all the dependencies of a table in SQL Server
- How to Find Objects Referencing a Table in SQL Server
- Case sensitivity in SQL Server
Categories
Popular Posts
Structured Data using FoxLearn.JsonLd
Jun 20, 2025
Implement security headers for an ASP.NET Core
Jun 24, 2025
What Are RESTful Web Services?
Feb 19, 2024
Plus Admin Dashboard Template
Nov 18, 2024