MSCEWI3085

CASCADE CONSTRAINTS modified inside DROP TABLE statement to CASCADE

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]​

MSCEWI3084

MSCEWI3086

Last modified 3mo ago