Version: 14.0.10-11
Build #: 37098
Build Date: 2014-Apr-04 05:44:58 PM
Qualify Object w/ Schema and Netezza 7.0.3 Multi Schema support
Issue 1
Go to File-> Options -> Scripts -> Netezza -> Qualify Object w/ Schema-> Disable
Go to AquaFold Database and expand test schema
Expand the Constraints node for test.ACTIVITIES
Script to window FK_PK
For any constraints like Primary, Unique we do not append the Database name. You can see that only for Foreign keys under keyword REFERENCES you have database name followed by 2 dots since we have disabled qualify object with Scheme.
Is this intended behavior ? While scripting it looks like this REFERENCES "AQUAFOLD".."activities"("activity_id").
See attached screenshot
Issue 2 with ER Modeler
Suppose I use the below scripts with the .. and Drop and Recreate the Foreign key using below script
You can see that under the Constraints node the Foreign Key is visible. But if you create an ER Model from diagram with Tools-> ER Diagram Generator and select Schema test under AQUAFOLD database, you can see that the ER Model comes up with no relationships even though the Schema Tree displays a relationship. See attached screenshot
ALTER TABLE "test"."ACTIVITIES"
DROP CONSTRAINT "FK_PK" CASCADE
GO
ALTER TABLE "test"."ACTIVITIES"
ADD CONSTRAINT FK_PK FOREIGN KEY("ACTIVITY_ID")
REFERENCES "AQUAFOLD".."activities"("activity_id")
ON UPDATE NO ACTION
ON DELETE NO ACTION
DEFERRABLE
INITIALLY IMMEDIATE
GO
extraction fix but rest is working correctly