Change column name in SQL Server 2014

Question

How to change the column name in SQL Server 2014 using query?

Please always google before asking question. – FLICKER Sep 29 '17 at 23:41 — FLICKER, Sep 29 '17 at 23:41

score 8 · Accepted Answer · edited Sep 29 '17 at 22:51

8

For this you can use this query

USE DATABASE;  
GO  
EXEC sp_rename 'TABLE.COLUMN_NAME', 'COLUMN_NEW_NAME', 'COLUMN';  
GO

You will have to replace DATABASE,TABLE,COLUMN_NAME and COLUMN_NEW_NAME with your data

edited Sep 29 '17 at 22:51

ChrisM

answered Sep 29 '17 at 22:38

Mircea Pop

@ChrisM yes his query is for Oracle SQL, I didn't comment on his answer cause i don't have enough rep :) PS: ty for the answer format edit – Mircea Pop Sep 30 '17 at 00:43
I thought it was as well. – ChrisM Sep 30 '17 at 00:50

1 Answers1