t sql - Error renaming a column in SQL Server with sp_rename in Microsoft Fabric - Stack Overflow

admin管理员组

文章数量:1347158

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.

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.

• sql-server
• t-sql
• microsoft-fabric

Share Improve this question Follow edited 2 days ago marc_s 756k184184 gold badges1.4k1.4k silver badges1.5k1.5k bronze badges asked 2 days ago CerberoCerbero 4588 bronze badges 10

• Gold.dbo.TEST_TABLE.OldTestColumn 4 part naming? Try connecting to the correct database and using 3 part naming. 4 part naming for sys.sp_rename likely isn't supported (it's not on on-premises). – Thom A Commented 2 days ago
• From the docs: "If the object to be renamed is a column in a table, object_name must be in the form table.column or schema.table.column." learn.microsoft/en-us/sql/relational-databases/… – Charlieface Commented 2 days ago
• I tried also with schema.table.column and I got the same error – Cerbero Commented 2 days ago
• 1 Also from the Documentation: "In sp_rename for the Warehouse in Microsoft Fabric, OBJECT is the only supported value for @objtype." – Thom A Commented 2 days ago
• 1 Nevermind, looks like renaming of columns is not supported. – Thom A Commented 2 days ago

 |  Show 5 more comments

1 Answer 1

Sorted by: Reset to default 3

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.

本文标签： t sqlError renaming a column in SQL Server with sprename in Microsoft FabricStack Overflow