User did a schema compare ALTSDDB and ALTSTDB, Toad found differences on constraint and generated DDL with mixed schema names.
For example:
ALTER TABLE "ALTStDB"."TCHEND"
ADD CONSTRAINT "CHIMPK2_FK" FOREIGN KEY
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
REFERENCES "ALTSdDB"."TCHIMP"
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
ON DELETE CASCADE
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center