Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 Team
Can you please let me know when the DEFAULT CONSTRAINTS will be added to Fabric Warehouse.
Thanks,
Keerthinath.C.M
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
-------------------------------------------------------
-----------------------------------------------
"
"
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |