Answers for "how to update a column name in sql"

modify column name in sql

ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

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;

sql change column name based on value

SELECT CASE lower(col1)
	WHEN 'agree' THEN 'Ok'
    ELSE
        CASE 
            WHEN col2 = 1 THEN 'Ko'
            ELSE 'Maybe'
        END
END AS my_result
FROM table_name;

sql alter column name sql server

EXEC sp_RENAME 'table_name.oldColumn_name' , 'newColumn_name', 'COLUMN'