update column name query in sql code example
Example 1: 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 2: modify column name in sql
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);
Example 3: change column name sql
ALTER TABLE users
ALTER COLUMN first username varchar(20);