CHECK CONSTRAINT

Description

Some parts in the output code are omitted for clarity reasons.

When the constraint that was being added in the SQL Server code is not supported at all in Snowflake, Snowconvert comments out the Check constraint statement, since it's no longer valid.

Sample Source Patterns

SQL Server

IN -> SqlServer_01.sql

ALTER TABLE
    [Person].[EmailAddress] CHECK CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID]
GO

Snowflake

OUT -> SqlServer_01.sql

ALTER TABLE IF EXISTS Person.EmailAddress
                                          !!!RESOLVE EWI!!! /*** SSC-EWI-0035 - CHECK STATEMENT NOT SUPPORTED ***/!!!
                                          CHECK CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID];

Known Issues

1. The invalid CHECK CONSTRAINT is commented out leaving an invalid ALTER TABLE statement.

Related EWIs

• SSC-EWI-0035: Check statement not supported.