MSCEWI1035

Check statement not supported.

Severity

Low

Description

This warning appears to indicate the CHECK constraint is not supported by Snowflake but it does not affect functionally.

Example Code

Oracle Input Code:

CREATE TABLE "Schema"."BaseTable"(
  "COLLUMN1" VARCHAR2(255),
  CHECK ( COLUMN1 IS NOT NULL )
);

Output Code:

CREATE OR REPLACE TABLE "Schema"."BaseTable" (
    "COLLUMN1" VARCHAR(255) /*** MSC-WARNING - MSCEWI1036 - VARCHAR2 DATA TYPE CONVERTED TO VARCHAR ***/,
--    --** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED **
--    CHECK ( COLUMN1 IS NOT NULL )
  );

Recommendations

Last updated