MSCEWI3084

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

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

This EWI is deprecated, for more information on this issue referred to MSCEWI1108

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