CHECK

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

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

Snowflake

OUT -> SqlServer_01.sql

ALTER TABLE IF EXISTS table_name
ADD column_name VARCHAR(255)
!!!RESOLVE EWI!!! /*** SSC-EWI-0035 - CHECK STATEMENT NOT SUPPORTED ***/!!!
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

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