ALTER TABLE Column rename? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

ALTER TABLE Column rename?

Author

Topic

henrikop
Constraint Violating Yak Guru

280 Posts

Posted - 2005-07-25 : 11:33:31

I can't find the syntax of changing a column name in T-SQL.

Is there something like:
ALTER TABLE table SomeTable RENAME column Field1 TO Field2

Henri
~~~~
The envious praises me unknowingly

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2005-07-25 : 11:37:01

sp_rename, check BOL for usage.

*need more coffee*
SELECT * FROM Users WHERE CLUE > 0
(0 row(s) affected)