Links

MSCEWI2033

Columns may be reordered.

Severity

Low

Description

The referenced table was not found during semantic analysis. The referenced columns may need to be reordered to preserve functionality. This is done automatically when the referenced table is found in the input code, as shown in MSCEWI2032.

Example Code

Input Code:

CREATE TABLE FK3(
COL1 INTEGER,
COL2 INTEGER,
COL3 INTEGER,
FOREIGN KEY (COL1, COL2, COL3) REFERENCES FK4 (COL1, COL2, COL3)
);

Output Code:

CREATE TABLE DATAWAREHOUSE.PUBLIC.FK3 (
COL1 INTEGER,
COL2 INTEGER,
COL3 INTEGER
);
/*** MSC-Low - MSCEWI2033 - REFERENCED TABLE NOT FOUND, REFERENCED COLUMNS MAY NEED TO BE REORDERED ***/
ALTER TABLE DATAWAREHOUSE.PUBLIC.FK3 ADD CONSTRAINT COL1
FOREIGN KEY (COL1, COL2, COL3) REFERENCES DATAWAREHOUSE.PUBLIC.FK4 (COL1, COL2, COL3) ;

Recommendations

  • Check if you are able to add the missing referenced table to your input code so that SnowConvert is able to automatically reorder the referenced columns.
  • 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.