Problem renaming column in Sql Server table

Question

I needed to rename a column from a table in Sql Server and used the stored SP_RENAME system processor.

I used it as follows:

USE [meu_db]
GO

EXEC sp_rename '[dbo].[minhaTabela].[minhaColunaAntiga]', '[minhaColunaNova]', 'COLUMN';  
GO

That is, I tried to change the name from 'myColunaAntiga' to 'myColunaNova', but the way I put it, sp_rename considered the characters '[' and ']' literal and the column became called '[myColunaNova]' instead of 'myColunaNew'.

Now I’m trying to fix it like this:

EXEC sp_rename '[dbo].[minhaTabela].[minhaColunaNova]', 'minhaColunaNova', 'COLUMN';  
GO

But it didn’t work.

I tried too:

EXEC sp_rename '[dbo].[minhaTabela].[[minhaColunaNova]]', 'minhaColunaNova', 'COLUMN';  
GO

But it didn’t work either. I even tried with 3 '[]' and it didn’t work either.

Someone would have an idea how to fix this?

Answer 1

From what I understand, you want to remove the brackets from the column name. To remove the brackets from the column name just insert quotes before the first bracket and after the last bracket.

As in the example below:

EXEC sp_rename '"[minhaColunaNova]"', 'minhaColunaNova';

Reference: How to Rename Something in SQL Server that has square Brackets in the name?

Answer 2

Just remove the keys from your first call:

USE meu_db
GO

EXEC sp_rename 'minhaTabela.minhaColunaAntiga', 'minhaColunaNova', 'COLUMN';  
GO

SP_RENAME

Changes the name of a user created object in the current database. This object can be a table, index, column, alias type data, or Microsoft . NET User-defined framework common language type Runtime (CLR).

SP_RENAME - B. Renaming a column

USE AdventureWorks2012;  
GO  
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';  
GO