sql query to change column name 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 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;
Example 3: alter table name sql
-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';
Example 4: sql rename column in select query
SELECT data.column AS `Label`