how to change the name of column in output table of sql code example

Example: alter table name sql

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