MSCEWI3085

CASCADE CONSTRAINTS modified inside DROP TABLE statement to CASCADE

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This warning is added when the CASCADE CONSTRAINTS clause is used inside the DROP TABLE. Snowflake supports a CASCADE clause, which has the same functionality as CASCADE CONSTRAINTS inside Oracle. The CONSTRAINTS then is removed leaving only the CASCADE clause.

Example Code

Input Code:

DROP TABLE table1 CASCADE CONSTRAINTS;

Output Code:

/*** MSC-WARNING - MSCEWI3085 - CASCADE CONSTRAINTS MODIFIED INSIDE DROP TABLE STATEMENT TO CASCADE. ***/
DROP TABLE PUBLIC.table1 CASCADE;

Recommendations

• No end-user actions are required.

• If you need more support, you can email us at [email protected]