query to change name of a column code example
Example 1: sql rename column
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
Example 2: how to change column name in mysql
alter table product change price price_kg float;
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
alter table product change price price_kg float;