MSCEWI3085
CASCADE CONSTRAINTS modified inside DROP TABLE statement to CASCADE
Low
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.
DROP TABLE table1 CASCADE CONSTRAINTS;
/*** MSC-WARNING - MSCEWI3085 - CASCADE CONSTRAINTS MODIFIED INSIDE DROP TABLE STATEMENT TO CASCADE. ***/
DROP TABLE PUBLIC.table1 CASCADE;
- No end-user actions are required.
Last modified 3mo ago