How do I include the 'USING INDEX' syntax for a Primary Key Constraint in a Forward Engineer scri (4294073)

Question:

How do I include the 'USING INDEX' syntax for a Primary Key Constraint in a Forward Engineer script when I have a model with Target Database: Oracle?

Answer:

1. Create a table with a Primary Key, right-click on the Table and select the 'Index Properties'

2. In the Index Editor, select the Constraint State tab and check the 'Using Index' box:

3. Navigate to the Actions menu > Forward Engineer > Schema > Select the Option Selection menu > Other Options and check the 'Constraint State' box:

4. Click the Preview button to see the following script with 'USING INDEX' syntax:

ALTER TABLE <Table Name>

ADD CONSTRAINT XPK<Table Name> PRIMARY KEY (<Column Name>)   USING INDEX XPK<Table Name>;