ALTER TABLE column_constraint (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-fabricsqldb] Specifies the properties of a PRIMARY KEY, FOREIGN KEY, UNIQUE, or CHECK constraint that is part of a new column ...

ALTER TABLE staging_data ALTER COLUMN extra_info SET DEFAULT 'hello'; -- also note that for big tables on busy DBs the above 2-step form is much preferred over below form as it won't re-write the ...

Memory Optimized Tables promise significant performance gains, but tend to be difficult to work with. SQL Server 2016 reduces much of the pain by offering ALTER TABLE support.