Microsoft Fabric Updates Blog

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

Related blog posts

Announcing: Fabric Warehouse support for sp_rename

May 16, 2024 by Dan Liu

Leverage the power of task flows to design and build your data solutions and manage workspace items in Microsoft Fabric. We’re thrilled to announce that the task flows feature is now in public preview and is enabled for all existing Microsoft Fabric users. Fabric is unifying everything needed to deliver end-to-end data and analytics solutions … Continue reading “Announcing the public preview of task flows in Microsoft Fabric”

April 24, 2024 by Liliam C Leme

In this new post of our ongoing series, we’ll explore setting up Azure Cosmos DB for NoSQL, leveraging the Vector Search capabilities of AI Search Services through Microsoft Fabric’s Lakehouse features. Additionally, we’ll explore the integration of Cosmos DB Mirror, highlighting the seamless integration with Microsoft Fabric. It’s important to note that this approach harnesses … Continue reading “Fabric Change the Game: Embracing Azure Cosmos DB for NoSQL”