/SQL/How to change a collumn name in sql

How to change a collumn name in sql

Sql rename column

-- 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'

How to change a collumn name in sql

ALTER TABLE `table_name` 
CHANGE `old_name` `new_name` VARCHAR(10) 
CHARACTER SET utf8 
COLLATE utf8_general_ci NULL 
DEFAULT NULL;

Rename column sql

ALTER TABLE nom_table
RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom

Source: sql.sh

Similar codes

0 vote201 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
28 votes181 views4 answers
Show tables mysql
SQL
0 vote195 views1 answer
How to get first 10 records of a table in mysql
SQL
4 votes190 views2 answers
Postgresql default value
SQL
1 vote220 views3 answers
Default password of mysql
SQL
0 vote176 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
3 votes153 views1 answer
Postgresql where current year
SQL
1 vote207 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
4 votes171 views3 answers
Mysql varchar length
SQL
0 vote179 views1 answer
Oracle archivelog usage
SQL