/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

1 vote168 views1 answer
Oracle boolean to varchar
SQL
0 vote214 views1 answer
Postgresql in vs any performance
SQL
1 vote277 views1 answer
Sql sort column by date
SQL
1 vote202 views1 answer
Oracle sql average
SQL
1 vote198 views1 answer
How to run sql script
SQL
0 vote221 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote194 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote206 views1 answer
Uncomment listen_address=localhost
SQL
1 vote217 views1 answer
Oracle sql pad left zeros
SQL
0 vote154 views1 answer
Ms sql print more than 1 variable
SQL