TABLE CONSTRAINT
Some parts in the output code are omitted for clarity reasons.
Description
Specifies the properties of a PRIMARY KEY, FOREIGN KEY, UNIQUE, or CHECK constraint that is part of a new column definition added to a table by using ALTER TABLE. (https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-column-constraint-transact-sql)
Translation for column constraints is relatively straightforward. There are several parts of the syntax that are not required or not supported in Snowflake.
These parts include:
CLUSTERED | NONCLUSTERED
WITH FILLFACTOR = fillfactor
WITH ( index_option [, ...n ] )
ON { partition_scheme_name ( partition_column_name ) | filegroup | "default" }
NOT FOR REPLICATION
CHECK [ NOT FOR REPLICATION ]
Syntax in SQL Server
Syntax in Snowflake
Sample Source Patterns
Multiple ALTER TABLE instances
SQL Server
IN -> SqlServer_01.sql
Snowflake
OUT -> SqlServer_01.sql
DEFAULT within constraints
SQL Server
IN -> SqlServer_02.sql
Snowflake
OUT -> SqlServer_02.sql