SSC-EWI-OR0067
Multiple constraint definition in a single statement is not supported in Snowflake.
Severity
Medium
Description
Multiple Constraint Definition in a single ALTER TABLE statement is not supported in Snowflake.
Example Code
Oracle:
ALTER TABLE TABLE1 ADD (
CONSTRAINT TABLE1_PK
PRIMARY KEY
(ID)
ENABLE VALIDATE,
CONSTRAINT TABLE1_FK foreign key(ID2)
references TABLE2 (ID) ON DELETE CASCADE);
Snowflake Scripting:
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0067 - MULTIPLE CONSTRAINT DEFINITION IN A SINGLE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
ALTER TABLE TABLE1
ADD (
CONSTRAINT TABLE1_PK
PRIMARY KEY
(ID) ,
CONSTRAINT TABLE1_FK foreign key(ID2)
references TABLE2 (ID) ON DELETE CASCADE);
Recommendations
No end-user actions are required.
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated