Recently, One of my friends asked How to rename a column by SQL command frankly speaking I am not used too of using this command I prefer UI interface.
Lets understand this by an example.
Suppose I have a users table in which there is a column with name status which should be statusId but by typo mistake I added satus column.
Now below is command to rename column
SP_RENAME ‘table.columnName’,’newcolumnname’,’COLUMN’
See below snap to resolve above problem of renaming satus to statusId
Enjoy!!!
RJ
