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 ...

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 ...

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.