MSCEWI1108

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.

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]