how to change name of column in sql code example

Example 1: how to change the column name in sql

ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;

Example 2: cmd to rename a collumn name in sql

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

Example 3: alter table name sql

-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';

Example 4: rename column sql

ALTER TABLE nom_table
RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom

Tags:

Misc Example

Related