can I alter a table column name thru TSQL

Question

Post reply

can I alter a table column name thru TSQL

yogiberr

Hall of Fame

Points: 3679
More actions
December 11, 2003 at 1:19 pm

#81696

Hi,

As far as i can see, there is no way to ALTER the "name" of a table column thru TSQL, though it seems that you can do everything else with a column thru the TSQL "ALTER" statement.

Is there a logical reason for this?Do I have to go to EM and manually change the name of the column that I want to alter?

Cheers,

yogiberr

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jxflagg Hall of Fame Points: 3817 More actions · Answer 1

jxflagg

Hall of Fame

Points: 3817

December 11, 2003 at 1:34 pm

#485827

sp_rename

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Frank Kalis

SSC Guru

Points: 111183

December 11, 2003 at 2:04 pm

#485838

sp_rename uses utilizes DBCC RENAMECOLUMN. As this command is undocumented, I guess there is no direct way with T-SQL.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

yogiberr Hall of Fame Points: 3679 More actions · Answer 3

thanks folks,

So, would I be best to:

1) use "sp_depends" on the table that I am about to alter (to find out which other db objects the column name-change could affect)

2) use "sp_rename" to rename the table column.

3) update all the objects that reference the renamed column.

Did i understand correctly?

ta,

yogiberr

Green Armchair Hall of Fame Points: 3561 More actions · Answer 4

Green Armchair

Hall of Fame

Points: 3561

December 12, 2003 at 1:36 am

#485881

Hi

What I usually do if I'm not sure how to do something in QA is to do what I want to do in EM in a test database and record it all through profiler. You can then pick out the QA commands required.