change field name in sql code example
Example 1: cmd to rename a collumn name in sql
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
Example 2: how to change column name in sql
ALTER TABLE Student RENAME COLUMN NAME TO FIRST_NAME;
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);
Example 3: modify column name in sql
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);
Example 4: rename column sql
ALTER TABLE nom_table
RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom
Example 5: change column name sql
ALTER TABLE users
ALTER COLUMN first username varchar(20);