Links

MSCEWI4021

If Statement With Object ID Removed

Severity

Low

Description

This EWI is added when SnowConvert removes an ObjectID function since its functionality is handled by the following statement. This happens when an ObjectID function is a condition for an If Statement and the body of this statement has a Create or Drop Table.

Code Example

Input Code:

IF OBJECT_ID(N'dbo.MyTable0', N'U') IS NOT NULL
DROP TABLE [dbo].[MyTable0];
IF OBJECT_ID('DBO.MYTABLE1', N'U') IS NULL
BEGIN
CREATE TABLE DBO.MYTABLE1(COL1 VARCHAR(200))
END

Output Code:

EXEC(`DROP TABLE IF EXISTS PUBLIC.TABLETEST`);
// ** MSC-WARNING - MSCEWI4021 - IF STATEMENT WITH OBJECT_ID FUNCTION REMOVED AND REPLACED FOR A CREATE OR DROP TABLE STATEMENT. **
EXEC(`DROP TABLE IF EXISTS dbo.MyTable0`);
// ** MSC-WARNING - MSCEWI4021 - IF STATEMENT WITH OBJECT_ID FUNCTION REMOVED AND REPLACED FOR A CREATE OR DROP TABLE STATEMENT. **
{
EXEC(`CREATE OR REPLACE TABLE DBO.MYTABLE1(COL1 VARCHAR(200))`);
}

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.