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

Last updated