(Kenneth Fisher) Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in the near future. There is a new command RENAME that is specifically for Azure SQL Data Warehouse and Parallel Data Warehouse.
/membership]
Read More (Community content)
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help