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 index_option (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-fabricsqldb] Specifies a set of options that can be applied to an index that is part of a constraint definition that is created by ...

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.