sql rename column when select code example

Example: rename column name sql server

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