CONNECTION
Last updated
Last updated
When CONNECTION clause is in the ALTER statement, Snowconvert will comment out the entire statement, since it is not supported.
ALTER TABLE bought
ADD COL2 VARCHAR(32), CONSTRAINT EC_BOUGHT1 CONNECTION (Customer TO Product, Supplier TO Product)
ON DELETE NO ACTION;
ALTER TABLE bought
ADD COL2 VARCHAR(32), CONSTRAINT EC_BOUGHT1
-- --** SSC-FDM-0014 - CHECK STATEMENT NOT SUPPORTED **
-- CONNECTION (Customer TO Product, Supplier TO Product)
--ON DELETE NO ACTION
;
1. ALTER TABLE CONNECTION clause is not supported in Snowflake.
The entire ALTER TABLE CONNECTION clause is commented out, since it is not supported in Snowflake.
SSC-FDM-0014: Check statement not supported.