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?
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>;