MSCEWI3002

Foreign key data type mismatch.

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

Severity

Medium

Description

This error happens when there is a mismatch in a foreign key data type.

Example Code

Input Code:

CREATE TABLE "MyDb"."MyTable"
(
    "COL1" NUMBER,
    CONSTRAINT "PK" PRIMARY KEY ("COL1")
);

CREATE TABLE "MyDb"."MyTable1"
(   
    "COL1" NUMBER(*,0),
    CONSTRAINT "FK1" FOREIGN KEY ("COL1") REFERENCES "MyDb"."MyTable" ("COL1")
);

Output Code:

CREATE OR REPLACE TABLE MyDb.MyTable ( COL1 NUMBER (38,19),
CONSTRAINT PK PRIMARY KEY (COL1));

CREATE OR REPLACE TABLE MyDb.MyTable1 ( COL1 NUMBER (38,0),
/*** MSC-ERROR - MSCEWI3002 - FOREIGN KEY DATA TYPE MISMATCH ***/
/*    CONSTRAINT FK1 FOREIGN KEY (COL1) REFERENCES MyDb.MyTable (COL1)*/);

Note that "MyDb"."MyTable1".COL1 and "MyDb"."MyTable".COL1 are of different types and the ERROR is displayed.

Recommendations

• Check for errors in the source code.

• If you need more support, you can email us at [email protected]