alter column name in mysql code example

Example 1: how to alter table name in mysql

ALTER TABLE table_name
  RENAME TO new_table_name;

Example 2: how ot change name of column mysql

ALTER TABLE tableName CHANGE `oldcolname` `newcolname` datatype(length);

Example 3: sql rename column

EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

Example 4: change column name mysql command line

ALTER TABLE `members` ADD COLUMN `credit_card_number` VARCHAR(25);

Example 5: how to change column name in mysql

alter table product change price price_kg float;

Example 6: modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';