microsoft sql server rename column code example

Example 1: rename column name sql server

EXEC sp_RENAME 'table_name.old_name', 'new_name', 'COLUMN'

Example 2: rename column sql

ALTER TABLE nom_table
RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom