Hi, I am trying to change a column name using what I found at
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
EXEC sp_RENAME 'RiskAdjust_Temp.dbo.WHP_W_1.PROD_CLIENT_CNTRCT_BID ’ , ‘PRODCLIENTCNTRCT_BID’, ‘COLUMN’;