[SOLVED] Error renaming a column in SQL Server with sp

Error renaming a column in SQL Server with sp_rename in Microsoft Fabric

I'm encountering an error while trying to rename a column in SQL Server using the following query:

EXEC sp_rename 'Gold.dbo.TEST_TABLE.OldTestColumn', 'NewTestColumn', 'COLUMN';

I get the following error message:

Msg 15600, Level 16, State 30, Line 897
An invalid parameter or option was specified for procedure 'sys.sp_rename'.

Msg 24528, Level 0, State 1, Line 1
Statement ID: {9626E836-C810-48E3-A9A7-D2BBD641B028}
3:31:04 PM SQL Server execution time: 00:00:00.112 | Total duration: 00:00:01.191

The column, table, and schema exist, and everything is properly referenced. I have tried different variations, but the issue persists. My environment is Microsoft Fabric, within Warehouse Gold.

Any suggestions on how to resolve this issue?

I tried renaming a column in a table within Microsoft Fabric using the sp_rename stored procedure. I expected the column name to be updated successfully without errors.

Solution

Renaming of columns is not supported (with sp_rename) in a Warehouse in Microsoft Fabric. From the documentation:

Applies to: Microsoft Fabric

In sp_rename for the Warehouse in Microsoft Fabric, OBJECT is the only supported value for @objtype.

In sp_rename for the SQL analytics endpoint in Microsoft Fabric, OBJECT is the only supported value for @objtype. Tables can't be renamed.

As such, you cannot change the name of a column in your table. You can only change the name of objects.