ninel
Ten Centuries
Points: 1027
More actions
August 9, 2006 at 10:58 am
#173765
I have table Employee. It contains the columns : name, phone, addr1
I would like to change the addr1 column to Address.
How can I do this?
John Rowan
SSC Guru
Points: 56440
August 9, 2006 at 11:13 am
#654141
Look up sp_rename in BOL.
============================================================================================================ Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden
Bhushan
Default port
Points: 1427
August 9, 2006 at 11:46 am
#654154
sp_rename 'Employee.addr1', 'Address', 'COLUMN'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply