The Options tab allows you to specify what script elements to generate for each object type.
By default, there is an entry in the left-hand pane under the meta-category "All Objects" for each object type present in your model, and all the possible options are displayed in the right-hand pane. If you click on an object type in the left-hand pane, then the options are restricted to that object type.
Depending on the objects present in your model, some or all of the following options will be available.
Parameter |
Description |
---|---|
Create <object> |
Generates the object. When generating primary, alternate, or foreign keys or indexes, you can choose between: The generation of keys or indexes outside the table is possible only if the Create entry exists in the Pkey, Key, Reference, and/or Index categories of your DBMS. |
Drop <object> |
Deletes an existing object, before recreating it. Note that when generating defaults, if the Create and Drop check boxes are selected, the default objects will be created/dropped before domains and tables. For more information on the default generation statement, see Customizing and Extending PowerDesigner > DBMS Definition Files. |
Begin script |
Inserts a customized script before creation of the object. |
End script |
Inserts a customized script after creation of the object. |
Physical options |
Generates physical options for the object. |
Comment |
Generates a comment for the object. |
Privilege |
[users, groups, and roles] Generates privileges for the user, group, or role. |
Permission |
Generates the permission statement for a given user during creation of the object. |
Check |
[domains, tables, and columns] Generates check parameters and validation rules for domains, tables, and columns. For table and columns, if this option is selected you can choose between: The generation of checks outside the table is possible only if the AddTableCheck entry exists in the Table category of your DBMS. |
Open database |
[databases] Opens the database. |
Close database |
[databases] Closes the database. |
Default value |
[domains and columns] Specifies a default value for the domain or column. |
Install JAVA class |
[abstract data types] Installs a Java class, which is stored on a server. |
Remove JAVA class |
[abstract data types] Deletes an existing Java class, before installing a new Java class. |
User-defined type |
[columns] Generates a user-defined data type for the column. |
Decl. Integrity |
[foreign keys] Generates declarative referential integrity for references specified to be Declarative in their property sheets. You can specify any or all of the following: |
Index Filter |
[indexes] You can specify from none to all of: |
Trigger Filter |
[triggers] You can specify the creation of triggers: |
Synonym Filter |
[synonyms] You can specify from none to all of: |
Force column list |
[views] Generates a view with a list of columns, even if this list is identical to the corresponding columns in the SQL order. Allows you to generate the list of view columns with the view creation order. By default, the list of view columns is generated only if it is different from the list of columns of the view query. For example, in the following view query: select a, b from Table1 columns a and b are view columns by default. The default generation statement is: create view V1 as select a, b from Table1 If you select the Force column list option, the generation statement will become: create view V1(a,b) as select a, b from Table1 |
You can save your option settings via the Settings set bar at the bottom of the tab. For more information, see Quick launch selection and settings sets.