ALTER TABLE support inside transactions (Generally Available) — Microsoft Fabric Roadmap

Description

Treating schema changes as transactional aligns with atomicity and isolation guarantees. If any part of the transaction fails, everything is rolled back, preserving data integrity. This capability is especially useful for automated pipelines and CI/CD workflows, where schema changes must be applied safely and predictably.With this release, Fabric Data Warehouse supports executing the following inside an explicit transaction:ALTER TABLE Add nullable columnsALTER TABLE Drop columnsALTER TABLE Add or drop NOT ENFORCED PRIMARY KEY, UNIQUE, and FOREIGN KEY constraintsExecute multiple ALTER TABLE statements atomicallyALTER distributed temporary tablesIf any operation fails, the entire transaction is rolled back automatically.

📰 Related Blog Article

ALTER TABLE inside explicit transactions in Fabric Data Warehouse (Generally Available)

🔗 blog.fabric.microsoft.com

Change History

2026-04-15

Release Status Planned -> Shipped Feature Description Treating schema changes as transactional aligns with atomicity and isolation guarantees. If any part of the transaction fails everything is rolled back preserving data integrity. This capability is especially useful for automated pipelines and CI/CD workflows where schema changes must be applied safely and predictably -> Treating schema changes as transactional aligns with atomicity and isolation guarantees. If any part of the transaction fails everything is rolled back preserving data integrity. This capability is especially useful for automated pipelines and CI/CD workflows where schema changes must be applied safely and predictably.With this release Fabric Data Warehouse supports executing the following inside an explicit transaction:ALTER TABLE Add nullable columnsALTER TABLE Drop columnsALTER TABLE Add or drop NOT ENFORCED PRIMARY KEY UNIQUE and FOREIGN KEY constraintsExecute multiple ALTER TABLE statements atomicallyALTER distributed temporary tablesIf any operation fails the entire transaction is rolled back automatically.
2026-04-07

Release Date 2026-04-07 -> 2026-04-13
2026-03-02

Release Date 2026-03-31 -> 2026-04-07
2025-12-04

Roadmap Item Added