MSCEWI2037

DELETE ALL was replaced to TRUNCATE.

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

Severity

Low

Description

DELETE ALL was replaced to TRUNCATE. It might be changed to DELETE if ACTIVITY_COUNT is needed.

Example Code

Input Code:

DELETE TABLE1 ALL;

Output Code:

TRUNCATE TABLE PUBLIC.TABLE1 /*** MSC-WARNING - MSCEWI2037 - DELETE ALL WAS REPLACED TO TRUNCATE, IT MIGHT BE CHANGED TO DELETE IF ACTIVITY_COUNT IS NEEDED ***/

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]