Sign in Get Started

modify column name in sql

Colin Milroy 
-- Oracle, MySQL 8+
ALTER TABLE table_name RENAME COLUMN current_name TO new_name;
-- MySQL < 8:
ALTER TABLE table_name CHANGE current_name new_name datatype(length);
-- SQL Server:
EXEC SP_RENAME 'table_name.current_name' , 'new_name', 'COLUMN'
View another examples Add Own solution
Log in, to leave a comment

3.43
7
Fiza 100 points 

                                    EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

3.43 (7 Votes)
0
3.9
9
Silence 110 points 

                                    ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

3.9 (10 Votes)
0
3.8
10
Andi 115 points 

                                    SELECT CASE lower(col1)
	WHEN 'agree' THEN 'Ok'
    ELSE
        CASE 
            WHEN col2 = 1 THEN 'Ko'
            ELSE 'Maybe'
        END
END AS my_result
FROM table_name;

3.8 (10 Votes)
0
3.8
10
Lars Stenberg 105 points 

                                    ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

3.8 (10 Votes)
0
4.14
7
Soltani 105 points 

                                    ALTER TABLE Student RENAME COLUMN NAME TO FIRST_NAME;
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

4.14 (7 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
sql change value name how to rename in sql how to rename column and change data type sql sql how to rename column in output alter table and rename column alter change table name update a column depending on the column name in sql server Changine column name in sql change the name of the coloumn in sql rename table column sql alter query to change column name change name on column on select how to change table name sql server make change to column name sql rename sql collum how to change sql column name how to change table name in sql SQL change field name as rename coloumn command in sql sql query change table name how to change column name in database rename column to name that in the table how to rename the table in sql rename table column edit table name sql how to edit table name in sql sql change name of value query sql rename table alter table column rename column how to change column name dynamically in sql rename a table column in sql sql rename all column how to change name in sql tbale select query change column name rename column and datatype in sql server change data type column name in sql how to rename table name in sql server how to alter the column name in sql ms sql rename column name how to change name of table in sql to rename column name in sql access rename column in query sql change name of column in select query change the name sql command alter change column name sql server alter column name how to change a col name in sql without rename alter table rename column name alter table modify rename column can alter command rename column change column name select sql change the table name in sql update a column value name in sql update a column data name in sql change name of column database how to rename a column name in sql server changing name of column in sql how to change a collumn name in sql sql set column name in query alter table rename column mssql change name of column in table alter table column name rename columns in sql in a vire change name of sql column sql rename column IN MSSQL change column name in sql select statement mssql rename table column name how to change name of column in sql rename in in sql renaming a acolumn using change comand sql sql change column name based on value sql server rename column in query mssql rename column in query sql rename column in select transact sql change column name change databse name sql modify column name sql change name of column in sql server sql rename table command how to rename a column in sqlplus table name rename in sql table rename sql query rename table in sql server how to change the name of database sql how to rename coumn sql rename mssql clumn sql ALTER TABLE RENAME COLUM sql query rename column how to change column name in table sql sql table rename rename column in mssql how to rename sql table systax changing the column name sql code rename table column name in sql server query rename syntax in sql how to rename column of table in sql sql rename column and change data type rename columns in sql server sql rename databvse name sql change column name when selecting rename column to a table sql server change a column name sql server alter to rename column in sql how to rename sql column sql server change table name change colum name sql sql rename colunm rename table sql change the name of a column in sql table how to chnage name of column in sql sql rename tab;e sql to rename table sql server sql edit column name update sql column name how to rename colunm name in sql server how to rename output coloumn in sql alter table change column name sql change name of column in select change column name and datatype in sql how to rename the column name in sql rename table name sql sql table rename column rename a column in sql server with alter table rename fields in sql sql for edit a column name alter table name in sql alter table edit column name sql change colum name alter table to rename column how to rename to table in sql arel table rename column name rename coloumn in sql renaming a colomn in sql how to rename table column name in sql change table name database sql how to modify the column name in sql rename property sql column mssql rename column that has [] change table column name in mssql alter sql column name chnage column name in sql techon the net alter name sql alter rename column in sql server change table name sql server renmae colummn name sql how to rename sql table alter column name in sql server CHANGE COLUMN NAME + SQL How do you rename column in tablei alter table sql statement to rename table sql change name of column rename column name in my sql how to rename column name in sql server alter table ALTER COLUMN NAME rename col_name from sql table rename column names in sql how to change the name of column in retiriving in sql alter sql table rename column alter the table name alter rename column how to change a columns name in sql server rename column swl sql server 2019 rename column renaming column header in sql rename a table sql how to change a column name in sql sql change field name and type how to alter table name in sql server how to change table name in microsoft sql sql rename select column command to change the name of a field in sql how to update column name in sql how to change a table name in sql from database how to rename a column on a SQL table and retain the data Write a query to rename a column ALTER TABEL Rename Column,SQL Server modify table name in sql server how to change existing column name in sql how to change column name in a table sql can we rename table in sql change the column name in sql how to alter column name in sql server t sql alter column name SQL change column name in table sql rename table command sql rename command query to rename a table in sql rename table column sql server sql rename column mssql how to alter sql column name alter table modify column name sql from command rename change column names in sql alter table rename columns mssql command HOW OT RENAME A DATABSE IN SQL sql server modify column name sql alter table name rename count column sql sql rename column in query output change column name in sql sql server command for change column name in sql rename col my sql sql command to rename a column alter table name sql sql server rename table rename any table column name rename columnin seql rename table in sql server by query db rename column how to set the field name in sql change table name inside sql rename selected column value in sql rename command in sql set name for column sql as set name for column sql how to modify column name in query set alter rename column name in sql rename a column in sql server changing column name in sql marigadb changing column name in sql alter column rename rename table query sql changing column name access changing the name of a column in sql SQL change name of field renaming a table in sql rename command in sql\ Write a syntax to rename table in sql how to alter column name in sql changing the name of a table in sql sql rename table column change table name column sql rename count column alter rename command in sql change table name in sql query rename as sql rename sql change name of column alter table rename sql table name ms sql rename column rename a column in sql select renane column sql alter table alter column name sql server sql query to change table name sql renaming column change column name in sql plus how to modify name of column in sql sql rename column in table modify table column name in sql alter table to rename table name in sql alter table rename column sql server change the name of table in sql change column name type in sql sql rename column? how to rename the column in sql server using script rename columns sql server how to rename the table name in sql rename the column name in sql rename column mssql how to rename table in sql renaming table column in sql sql syntax to rename a column in sql server change table name sql sql change coloumn name sql changecolum name table name change in sql query to rename column name in sql alter column name ms sql server sql rename databse how to change the column name in sql server how to change the column name in sql change table column name how to alter data name in sql text funtion rename column sql sql server alter rename column name editing a table column name in sql how to rename table name in sql query sql rename column name query how to change the column name and datatype in sql rename table sql server sql join rename column alter table to rename a column rename column name in sql select statement change a table name in sql Rename table command in sql how to rename column in sql change table column name in sql change column name in sql sybase how to modify database table column name in sql changing column names in query sql rename column and apply operation how to rename a table in sql alter column name SQL Server sql rename change name of column in access query change name of column name sql access can you change a name of a column in mssql using a command? rename column name in sql server 12 renametable name in sql how to rename table name in sql access sql rename column alter table rename column microsoft sql server change table name in sql change table name in sql server how to change the name of a column in sql w3 how to change the table name in sql server sql server replace column name rename table sql SQL change column name column how to rename columns and use in where clause in sql alter column name sql rename table rename colum in microsoft sql how rename column name in sql server how to rename sql server table name modify in sql change column name edit name of a column column rename sql rename column in sql sql dml rename column how to rename a colum in sql rename table name in sql ms sql server rename column name how to rename a column in sql query change table name sql sql server change name of column rename table in sql how to change column name in sql management studio change name of sql table how to change name column in sql rename a table in sql how can we rename the column name in sql rename a column in database change column name in sql output rename table name in sql server how to change table name in sql server how to alter table name in sql cast column as varchar sql alter column unique mysql howto change the name of a column in sql rename column t-sql query rename column name table column name change in sql server sql rename column\ change name of element in table sql alter rename in sql sql rename fields oracle rename query column mariadb rename columns in sql rename tebmle sql change a name column in sql renaming column in sql Change the name of column in query table rename in sql how to rename the coloumn data in mssql how can i rename collum by sql how to rename column name in mssql giving new name to column in sql to change column name in sql changing column name in sql server how to alter the name of a column in a table sql alter table edit column type syntax rename column from table in sql server sql change a coloumn name change palace of column in sql renaming column name in sql rename sql tables alter colum name in sql srever update the column name in oracle can we change the name of the column using alter how to change the name of an sql table column name change in sql server alter table rename sql server column sql command to change column name rename a feild in a database rename of column in sql alter database column name sql alter table sql change name changing table name in sql alter existing column name in sql server renaming sql table rename sql tabl change column collation sql server table name alter in sql sql column name rename column rename mssql change column value sql in database alter table in sql change data type sql rename a column alter table table_name add column in sql alter column type in sql server sql rename column name change database table column name sql alter table rename column sql server change name of column sql can you rename sql column change name column in sql ALTER table field name rename column inahlt sql RENAME COLUMN T - SQL renaming in sql how to change column name in azure sql database add column in sql table in sql change the field type in mysql column rename qry in ms sql sqlserver rename column name alter table and add column in mysql table alter a row name in sql sql server alter table rename column how to change name of a column in sql sql how to rename a column rename column in sql view SQL how to change column name of result rename attribute in mysql rename sql table query alter attribute name how to change cokumn's name in SQL Server how to change the name of column in output tableof sql sql alter table rename column rename sql command how to change name in sql create table in sql and alter add column how to set the name attribute in sql rename a row in sql rename of column in sql server sql alter name table change the name of field sql server sql changing field name how to change the name of an attribute in sql oracle sql rename variable change only one column name in sql rename column ms sql sql change name on table column name change in sql change sql column name sql from rename which command to do wee use in SQL to rename a column change name table sql change feild name sql edit a column name sql how to rename column name in sql updating column anme how to change name of existing table in sql rename a coulumn rename column tsql Alter the name of a column how to rename columns in sql sql server sp_rename column can we rename column name in sql alter table with name - how to rename the column name in sql server sql server alter column change name of column sql server update table name in sql sql change row name alter table edit column name sql server rename column sqlserver alter table change name alter table name tsql alter table name alter column change column name mssql rename row in sql script to rename column in sql rename attribute in sql how we can add column to a table sql update column name rename the table name in sql column rename in sql edit mssql column name rename column in sql query sql statement to change the name of a column hwo to modify column name in a table in sql rename columnt in sql SQL change table column name sql command to modify column name column rename in sql server how to change a column's name in sql alter table change attribute name column rename sql server how to rename a column name in sql sql querry to rename a table alter table update column name renameupdate table column sql alter table rename rename sql column name sql update name of column query to rename table how to rename column in sql table alter table rename table change name of a column sql sp rename sql column sql server change column name alter table how to change the name of a column in sql change name of a column in sql change column name in ms sql alter colomn name renaming example in sql change columnname sql sql serverv rename column to rename a column or table in a database alter column name in mssql sql command for rename column name how to chage column name to sql table change name in table sql change column name sql server update column name in mysql sql alter table change name sql alter table rename cange column name sql modify name of column in sql change name of column in mysql cahnge sql table name change a column name sql mssql change col name modify the column name in sql change col name in mssql how to change the name of the column in sql server attribute name in sql direct rename modify name column sql sql renmae table query to modify column name in sql how to edit a column with sql rename COlumn change name of column in sql how to rename a column sql modify command in sql can we change column name in sql rename column name in mssql alter name of column in sql server sql rename columns change field name in sql RENAME table SQL change name in the Persons table? SQL HOW TO RENAME COLUMN mysql alter table modify column name renaming a column in sql alter table sql renam eoclumn sql server update column name mysql change table rename column mysql rename colum name sql to rename table sql server rename column in table sql set table column name update table field name in mysql ALTER TABLE table_name RENAME COLUMN old_name TO new_name; how to rename field name in sql mysql alter table rename column sql server change name of column sql rename table name tsql server update coulmn name mssql rename column name sql server change column name change table name in ssql renaming column in sql server my sql change filed name rename a column in a table sql rename a column in a table sql server sp_rename column in sql server sql syntax for rename alter table change column name mysql how to change name of column sql sql query to change the name of a column rename the table in sql mssql rename column alter sql server column name change name of colum in sql table sql server rename column query update column name mssql update column name sql change row name in sql how ot change name of column sql alter table column name ,mysql changing the column name sql tsql update column name change row name sql rename column name sql renaming sql column changing Column Name in native query change column name of query as change column name of query edit table column name sql change collom nam sql SQL change table name sql rename column not working rename column sql query how to change a name in a column to another in tsql how to change a name in a column to another in sql alter table column to different name in sql rename colum sql command rename query in sql tsql table alter one field data type how to change the name of a field in sql alter table column name in mssql update column name in mssql how to rename an attribute in sql update column name in sql data alter name column sql sql sp_rename column rename columnusing sql script ms sql change column name sql rename column after query change the name of the table in sql how to set name in sql how to edit header of table in sql rename sql column sql query to rename column name SQL Query to change Column name select change column name mysql t-sql alter table change column name sql statement to change a field name rename colum in mysql change column name tsql update column name tsql rename a sql column that is a number ssql change column name how to update a column name in sql sql to rename column sql modify a colomn name sql rename column in query rename column name in sql server SQL statement to rename a column name sql query to rename table name how to rename result column in mysql query rename column in mysql rename column name in sql table sql add a column to a table from query change column name in mysql server change column name and datatype in sql server how to change attributes name in sql sql alter table change column name renaming a column in mysql sql how to change column name sql developer sql how to change column name how to rename a column in sql sp_rename example column sql rename column script how to change the row name in sql mysql rename a column in a table mssql alter table rename column change column name in sql server How can we rename a column in MySQL table? update column name query in sql alter column name in mysql rename columns sql based on their name rename field sql server change columname in mysql rename col sqlserver renaming columns in sql replace all name in column sql change column name mysql&ugrave; sql change column name in query t sql rename a column sql update field name rename field in sql renmae field in sql table change column name on table sql change attribute name in sql sql rename field in table change column name on query sql rename a column mysql how to edit a column name in sql change column name in sql server query changing column name in tables with alter sql changing column name in tables sql mysql rename colomn in result how to change row name in sql update name of column in sql how to change a db column name in mysql alter column name tsql mssql change column name how to change column name in sql server how to change column name in sqlserver rename column in sql server rename column mysql how to change column name in my sql rename column in sql table mysql rename column how to change the column name in sql query sql alter column name t sql rename column how to name a column in sql how to rename column name sql rename a colums chnage column name mysql column name rename in sql server column name rename rename column from table in sql sql query to rename the data in column cmd to rename a collumn name in mssql cmd to rename a collumn name in sql rename a column sql sql change column name in a table change name in sql sql column rename query change name column sql rename columns sql alter column name in sql sql modify column name how to change column name in sql comand sql update a column name rename a column name in sql how to change name of column name in mysql canghe name of column slq sql server rename column change column name sql change column name in mysql rename column sql server update column name in sql how to modify a column name sql how to modify a column name how to change a field name in sql rename column name mysql alter column name sql sql statement rename column sql how to rename a field how to rename a field in sql how to change the name of column in sql rename a field in sql change a column name in sql alter table rename column query to change name of a column changing the column name in mysql which query change column name in sql sql rename query query to change column name in sql server modify column name in sql rename a column in sql how to change column name in sql CAHNGE OLUMN NAME IN SQL query to alter column name in sql rename column name in sql how to alter table column name in sql how to chnage existing table column name in sql rename row name in sql rename in sql command to rename an attribute in a sql table how to edit column name in sql how to update column name sql rename column sql how to change column name sql sql change column names to change column name sql sql change column name sql rename column
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source