But take in mind what I wrote about in the first article, then references to the original name are not updated inside the scripts. For tables, and columns it's ok to use it, as the table names and column names are stored only in the sytem tables. So when you script-out the SP, FN, View etc., then you will see the original name in the script. Renaming a dedicated SQL pool in Azure Synapse Analytics workspaces isn't currently supported. Renaming standalone dedicated SQL pools (formerly SQL DW) is supported. To rename a database in Azure SQL Database, use the ALTER DATABASE (Azure SQL Database) statement. This is because it renames the object only in the system tables, but doesn't alter the name in definition. To rename a database in SQL Server, use the stored procedure sprenamedb.

There is written that you should not use it to rename stored procs, views, functions etc. **Edit:** I only add to what is written in BOL. they will not be automatically updated to new names. You must modify any objects that reference the renamed object manually. Only remember if you use the tables, fields in other stored procs, views etc. Applies to SQL Server (all supported versions), Azure SQL Database, and Azure Synapse Analytics: Renaming an object such as a table or column won't automatically rename references to that object. You can rename the field names or table names using the `sp_rename`.

Sql server rename column