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 table_name
ADD column_name VARCHAR(255) 
CONSTRAINT constraint_name 
CHECK NOT FOR REPLICATION (column_name > 1);

Snowflake

-- ** MSC-ERROR - MSCEWI4058 - ONE OR MORE OF THE TABLE ELEMENT PARTS ARE NOT SUPPORTED IN SNOWFLAKE: CHECK COLUMN CONSTRAINT **
--ALTER TABLE table_name
--ADD column_name VARCHAR(255)
--CONSTRAINT constraint_name
--CHECK NOT FOR REPLICATION (column_name > 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

• MSCEWI1058: One or more of the table element parts are not supported in snowflake