Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have been trying to add a DEFAULT constraint to a COLUMN. I saw at least one 2023 post stating to check SQL surface area that, as it read says that the ALTER TABLE is not supported, I added a PRIMARY KEY CONSTRAINT using an ALTER TABLE... it just works and therefore the documentation may need some updates.
I have not found any sample or discussion on the use of ALTER TABLE to specify a DEFAULT value. Since the documentation is not current there may be a way... the samples of ALTER TABLE to add a DEFAULT CONSTRAINT works well in on-prem SQL-SERVER but not in Microsoft Fabric Data Warehouse.
Hope that someone have some news about this...
Solved! Go to Solution.
Hi @esobrino default constraints are not supported currently as per the documenation here: Primary, foreign, and unique keys - Microsoft Fabric | Microsoft Learn
There's no news when they will be public either.
The ALTER TABLE support in the T-SQL Surface Area documenation states "
And as you've discovered, ALTER TABLE is supported when creating unique, primary key, and foreign key constraints.
T-SQL surface area - Microsoft Fabric | Microsoft Learn
I hope that helps
-------------------------------------------------------
If my post has been useful, please consider
provising Kudos and/or accepting as the Solution
-------------------------------------------------------
-----------------------------------------------
"
"
Hi @esobrino default constraints are not supported currently as per the documenation here: Primary, foreign, and unique keys - Microsoft Fabric | Microsoft Learn
There's no news when they will be public either.
The ALTER TABLE support in the T-SQL Surface Area documenation states "
And as you've discovered, ALTER TABLE is supported when creating unique, primary key, and foreign key constraints.
T-SQL surface area - Microsoft Fabric | Microsoft Learn
I hope that helps
-------------------------------------------------------
If my post has been useful, please consider
provising Kudos and/or accepting as the Solution
-------------------------------------------------------
-----------------------------------------------
"
"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |