CONNECTION
Description
When CONNECTION clause is in the ALTER statement, Snowconvert will comment out the entire statement, since it is not supported.
Sample Source Patterns
SQL Server
ALTER TABLE bought
ADD COL2 VARCHAR(32), CONSTRAINT EC_BOUGHT1 CONNECTION (Customer TO Product, Supplier TO Product)
ON DELETE NO ACTION;
Snowflake
ALTER TABLE IF EXISTS PUBLIC.bought ADD COL2 VARCHAR(32)
--** MSC-ERROR - MSCEWI4058 - ONE OR MORE OF THE TABLE ELEMENT PARTS ARE NOT SUPPORTED IN SNOWFLAKE: CONNECT TABLE CONSTRAINT **
--CONSTRAINT EC_BOUGHT1 CONNECTION (Customer TO Product, Supplier TO Product)-ON DELETE NO ACTION,
;
Known Issues
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.
Related EWIs
MSCEWI4058: One or more table elements parts are not supported in Snowflake.
Last updated
Was this helpful?