Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

kecona

Announcing: Fabric Warehouse support for sp_rename

We are excited to announce that the Data Warehouse now supports sp_rename.

With sp_rename, you can rename user objects like Tables, Stored Procedures, Functions etc.

Here is an example of how to use sp_rename that fixes a spelling mistake for city:

sp_rename [dbo.dimension_ctiy], [dimension_city];

When you use these features, change the schema an object belongs to or drop a table, the changes will be reflected in OneLake within 1 minute.

For More information, please see our documentation:

sp_rename (Transact-SQL) - SQL Server | Microsoft Learn