Toad World® Forums

Changing a column name


#1

Hi, I am trying to change a column name using what I found at

http://stackoverflow.com/questions/13047746/changing-column-name-in-a-sql-server-table-with-1000-records

Other reference sites contain similar instructions.

But the column name does not change.

Here is my attempt.

SELECT * INTO RiskAdjust_Temp.dbo.WHP_W_1a

FROM RiskAdjust_Temp.dbo.WHP_W_1

EXEC sp_RENAME 'RiskAdjust_Temp.dbo.WHP_W_1.PROD_CLIENT_CNTRCT_BID ’ , ‘PRODCLIENTCNTRCT_BID’, ‘COLUMN’;

Any ideas?

Thank you.


#2

Why not use SSMS and do it without code?

In SSMS right click the Table and select Design. Change the name and click save. Done!

If you get an error you may have to disable the prevent saving changes that require table re-creation setting. In SSMS select tools - > options, click Designers, uncheck Prevent saving changes that require table re-creation, click OK


#3

Hi wzubke, I am using TOAD and I do not see a choice called design when I rt click on the table?

Thanks


#4

I have not used TOAD for this type of management of SQL Server. SSMS is a free application from Microsoft if you want to go that route.

That being said TOAD should have the same type of functionality. Find the table on your Object explorer right click and select ALTER TABLE select Colunms change and click OK.


#5

Thanks got it!