Data Warehouse Alter Table add default value constraint

Hi esobrino default constraints are not supported currently as per the documenation here: Primary, foreign, and unique keys - Microsoft Fabric | Microsoft Learn 

• SQL analytics endpoint and Warehouse don't support default constraints at this time.

There's no news when they will be public either.

The ALTER TABLE support in the T-SQL Surface Area documenation states "

• ALTER TABLE ADD/ALTER/DROP COLUMN

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

-------------------------------------------------------

-----------------------------------------------

"

"