Table does not compare

Maxmix

Member³
As always, I compare schemaB to schemaB, connecting as schemaA.

For one table in schemaB, having FK pointing to another schemaC table, sync SQL is generated incorrectly.

Correct DDL:
create table "SCHEMAB"."CHILD_T"
..............
CONSTRAINT "FK_KNA_ENT" FOREIGN KEY ("KNA_SRC")
REFERENCES "SCHEMAC"."TGK_ENTERPRISES" ("ENT_TAG") ENABLE,
..............

loses SCHEMAC piece upon comparison like this:

alter table SCHEMAB.CHILD_T
add constraint FK_KNA_ENT foreign key (KNA_SRC)
references SCHEMAB.TGK_ENTERPRISES (ENT_TAG);

 
Back
Top