How to rename a column?
perels
Posts: 2
Hi,
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?
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
Comments
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!
Red Gate Software