MSCEWI2033
Columns may be reordered.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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.
If you need more support, you can email us at [email protected]
Last updated