Is there an easy way to rename a column in script without copying to a temp
table and back?

ALTER TABLE doesn't seem to have an option to do that.

Thanks,

Tom

Use the sp_rename system stored procedure. See Example B in this Books
Online topic: http://msdn.microsoft.com/en-us/libr...1(SQL.90).aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
"tshad" <toms (AT) pdsa (DOT) com> wrote