How to rename a column?

perelsperels Posts: 2
edited October 3, 2008 9:06AM in SQL Refactor Previous Versions

I am not sure how to Smart Rename a table column. I only see the option of Smart Renaming when I right-click on tables, views, procs and functions. I am using v. 1.300.207 of SQL Refactor on a Vista x64 Business machine.

Maybe I am missing something, but here is what I do;
Right-click appropriate table, the select Design. All the columns will then be listed with name, datatype etc. Then I right-click on the e.g. the primary key column (in this case it is called NewsID). The options available are only
"Remove primary key"
"Insert column"
"Delete column"
and other Microsoft-options - but nothing from Red-Gate.
How do I "Smart Rename" a column in a table?
Microsoft SQL Server Management Studio						9.00.3042.00
Microsoft Analysis Services Client Tools						2005.090.3042.00
Microsoft Data Access Components (MDAC)						6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML						3.0 4.0 5.0 6.0 
Microsoft Internet Explorer						8.0.6001.18241
Microsoft .NET Framework						2.0.50727.3053
Operating System						6.0.6001


  • You can do this directly from the Object Explorer.

    If you navigate down from the table to the column in the Object Explorer, and right click on it, you should then see Smart Rename... on the context menu.

    Please let me know if the option isn't there for you!
    Charles Brown
    Red Gate Software
Sign In or Register to comment.