Description:
How to get Oracle (10g/11g/12c) Forward Engineer to include ‘USING INDEX’ syntax for Primary Key Constraint in erwin Data Modeler?
Solution:
Highlight and Right Mouse Click on the Table and choose Index Properties. In the Index Editor -> Constraint State Tab, need to check the 'Using Index' checkbox, for the Primary Key Index.
Then in Forward Engineer Option Set, check ‘Constraint State’ checkbox under Other Options.
You will now have SQL Syntax like:
ALTER TABLE <Table Name>
ADD CONSTRAINT XPK<Table Name> PRIMARY KEY (<Column Name>) USING INDEX XPK<Table Name>;
Comments
0 comments
Please sign in to leave a comment.