rename a column

Ddd
Posted by Ddd under Sql Server category on | Points: 40 | Views : 1330
suppose we have a column known as ename in emp. we want to change its name to
empname

sp_rename 'emp.ename' ,'empname'

Comments or Responses

Login to post response