MSCEWI4021
If Statement With Object ID Removed
Low
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.
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
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))`);
}
- 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.
Last modified 1yr ago