CHECK
Last updated
Last updated
When CHECK clause is in the ALTER statement, Snowconvert will comments out the entire statement, since it is not supported.
ALTER TABLE table_name
ADD column_name VARCHAR(255)
CONSTRAINT constraint_name
CHECK NOT FOR REPLICATION (column_name > 1);
ALTER TABLE IF EXISTS table_name
ADD column_name VARCHAR(255)
----** SSC-FDM-0014 - CHECK STATEMENT NOT SUPPORTED **
--CONSTRAINT constraint_name
--CHECK NOT FOR REPLICATION (column_name > 1)
;
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.
SSC-FDM-0014: One or more of the table element parts are not supported in snowflake