To define schema generation index options
The Forward Engineer Schema Generation dialog opens on the Options tab.
Create an index on the primary key in each table.
Create an index for each alternate key in each table.
Create an index for each foreign key in each table.
Create an index on the inversion entry in each table.
Drop primary key indexes in each table.
Drop alternate key indexes in each table.
Drop foreign key indexes in each table.
Drop inversion entry indexes in each table.
Create a clustered or clustered hashed index in the generated schema.
Include index physical storage information in the generated schema.
Note: This option is not available for SQL Azure.
Include a UNIQUE PRIMARY INDEX clause in the generated schema.
Create an ASCII file that you must run on the target server to create the index.
Create partitioned indexes. This option is only available for Oracle.
Override the owner name indicated either in the Index Editor, or in the Model Editor, Defaults tab. When you click the Override Owner option, a new dialog opens, in which you indicate the owner name to use for the override. When you generate the schema during forward engineering, this name overrides other owner names you previously indicated.
Click Generate to start the schema generation process for forward engineering or alter script generation or OK to save the changes and close the dialog.
Copyright © 2017 erwin Inc.
All rights reserved.
|
|