MSCEWI1002

Removed next statement, not applicable in SnowFlake.

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

Severity

Low

Description

This warning appears when a specific statement is not applicable in Snowflake, it means that there is no Snowflake equivalent for this statement and it is no longer needed, and for that reason, it is removed from the source code. However, SnowConvert still keeps the original statement as part of the comment at the end.

Example Code

Input Code:

CREATE TABLE "Schema"."BaseTable"(
"PROPERTY" VARCHAR2(64) CONSTRAINT "MICROSOFT_NN_PROPERTY" NOT NULL ENABLE
);

Output Code:

CREATE OR REPLACE Schema.PUBLIC.BaseTable
(
PROPERTY VARCHAR(64) NOT NULL /*** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. CONSTRAINT MICROSOFT_NN_PROPERTY ***/
);

Recommendations

Last updated