MSCEWI3084

Snowflake does not have a PURGE clause inside the DROP TABLE statement

Severity
Low
Description
This warning is added when the PURGE clause is used inside the DROP TABLE. There is no equal clause available in Snowflake for PURGE, thus removing it from the statement.
Example Code
Input Code:
DROP TABLE table1 PURGE;
Output Code:
/*** MSC-WARNING - MSCEWI3084 - PURGE REMOVED FROM DROP TABLE STATEMENT. ***/
DROP TABLE PUBLIC.table1;
Recommendations
No end-user actions are required.
If you need more support, you can email us at [email protected]​
​

MSCEWI3083

MSCEWI3085

Last modified 3mo ago