Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
-------------------------------------------------------
-----------------------------------------------
"
"
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |