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
!!!RESOLVE EWI!!! /*** SSC-EWI-0035 - CHECK STATEMENT NOT SUPPORTED ***/!!!
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
SSC-EWI-0035: Check statement not supported.
Last updated