MSCEWI2037

DELETE ALL was replaced to TRUNCATE.

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.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.