|
Hi Friends :
I have the follow situation working with
designer ...
I have a table A. The owner�s table is application
A, user SCHEMA_A.
This table is shared with application
B.
Then
I have application B and inside it tables that do references with table
A.
When i genereate database from server model, it
doesn�t genereate for me the correct reference in the script.
ALTER TABLE XXX ADD CONSTRAINT
FK_XXX FOREIGN KEY (FIELD1) REFERENCES A (FIELD1)
the correct is :
ALTER TABLE XXX ADD CONSTRAINT
FK_XXX FOREIGN KEY (FIELD1) REFERENCES SCHEMA_A.A (FIELD1) Does anyone know how to do it ?
Eriovaldo do Carmo Andrietta
Limeira/SP - Brasil |
