CHECK

Description

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

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

IN -> SqlServer_01.sql

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

Snowflake

OUT -> SqlServer_01.sql

--ALTER TABLE dbo.doc_exd
--ADD CONSTRAINT exd_check
----                         --** SSC-FDM-0014 - CHECK STATEMENT NOT SUPPORTED **
--                         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-FDM-0014: Check statement not supported.