CHECK

Description

When CHECK clause is in the ALTER statement, Snowconvert will comments out the entire statement, since it is not supported.

Sample Source Patterns

SQL Server

ALTER TABLE dbo.doc_exd    
ADD CONSTRAINT exd_check CHECK NOT FOR REPLICATION (column_a > 1); 

Snowflake

-- ** MSC-ERROR - MSCEWI4058 - ONE OR MORE OF THE TABLE ELEMENT PARTS ARE NOT SUPPORTED IN SNOWFLAKE: CHECK TABLE CONSTRAINT **
--ALTER TABLE dbo.doc_exd
--ADD CONSTRAINT exd_check CHECK NOT FOR REPLICATION (column_a > 1)
                                                                 ;

Known Issues

1. ALTER TABLE CHECK clause is not supported in Snowflake.

The entire ALTER TABLE CHECK clause is commented out, since it is not supported in Snowflake.

Related EWIs

• MSCEWI4058: One or more table elements parts are not supported in Snowflake.