MSCEWI2033
Columns may be reordered.
Low
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.
CREATE TABLE FK3(
COL1 INTEGER,
COL2 INTEGER,
COL3 INTEGER,
FOREIGN KEY (COL1, COL2, COL3) REFERENCES FK4 (COL1, COL2, COL3)
);
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) ;
- 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.
Last modified 1yr ago