Syntax: sp_rename 'schema_name.table_name.old_column_name', 'new_column_name', 'COLUMN' In SQL Server, you’ll need to use the sp_rename stored procedure to rename a column. This syntax is still supported in later versions of MySQL and MariaDB, although they now also have the previous RENAME COLUMN syntax that makes it easier. Note that this syntax requires that you respecify the column definition even if you’re only renaming it. In MySQL prior to version 8.0, and MariaDB prior to 10.5.2+, you’ll need to use the CHANGE COLUMN syntax instead.ĬHANGE COLUMN old_column_name new_column_name datatype ĬHANGE COLUMN ProdDesc ProductDescription varchar(500) MySQL and MariaDB didn’t always support the RENAME COLUMN syntax. That should work in RDBMSs including PostgreSQL, Oracle, SQLite, MySQL (starting with 8.0), and MariaDB (starting with 10.5.2+). PostgreSQL rename column script In Postgresql, the column can be renamed using the script, the script is a file where we write the SQL queries that we want to execute and the file is saved with extension (.sql). Here, we renamed a column in the Products table from ProdDesc to ProductDescription. RENAME COLUMN ProdDesc TO ProductDescription RENAME COLUMN old_column_name TO new_column_name Most of the major RDBMSs allow you to rename a column as follows. Most of the major RDBMSs allow you to rename a column with the ALTER TABLE statement. In order to make changes in the names or columns of a table for an appropriate business understandable name, we get the concept RENAME. This article provides a quick example of renaming a table in SQL.

Sql server rename column