EXEC sp_rename not working in Azure Synapse

Question

I am using the following code :

EXEC sp_rename  'oldname' 'newname'

and I am getting this error :

An insufficient number of arguments were supplied for the procedure or function sp_rename

Answer 1

The sp_rename is still in preview in Azure Synapse Analytics.

For now, you can only rename columns : https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-ver16

Answer 2

If you are looking to rename objects like a table, you can use RENAME (T-SQL)

Ref: https://learn.microsoft.com/en-us/sql/t-sql/statements/rename-transact-sql?view=aps-pdw-2016-au7

Answer 3

sp_rename is in preview in Azure Synapse Analytics:

Applies to: Azure Synapse Analytics In sp_rename (preview) for Azure Synapse Analytics, COLUMN is a mandatory value specifying that the object type to be renamed is a column, and must always be included in the sp_rename statement. A column can only be renamed if it's not a distribution column.

So it appears you can only rename columns at present.

similar thread :

https://stackoverflow.com/questions/77428611/insufficient-number-of-arguments-for-sp-rename-in-synapse-stored-procedure