Script/Objects Category (DBMS)

The Objects category is located in the Root > Script > SQL category (and, possibly within Root > ODBC > SQL), and contains the following items that define the database objects that will be available in your model.

The following items are located in the Root > Script > Objects and Root > ODBC > Objects categories, and apply to all objects:

MaxConstLen - Specifies the maximum constraint name length supported by the target database for tables, columns, primary and foreign keys. This value is used during model checking and returns an error if the code exceeds the defined value. The constraint name is also truncated at generation time.
Note: PowerDesigner has a maximum length of 254 characters for constraint names. If your database supports longer constraint names, you must define the constraint names to fit in 254 characters or less.
EnableOption - Specifies that physical options are supported by the target DBMS for the model, tables, indexes, alternate keys, and other objects and enables the display of the Options tab in object property sheets. For more information, see Physical Options (DBMS).
GenerationOrder - Specifies the generation order of database objects. Drag and drop entries in the Ordered List tab to adjust the order in which objects will be created.

Note: If an object does not appear on the list, it will still be generated, but after the listed objects. You can add and remove items using the tools on the tab. Sub-objects, such as Sequence::Permissions, can be placed directly below their parent object in the list (where they will be indented to demonstrate their parentage) or separately, in which case they will be displayed without indentation. Extended objects (see Generating and Reverse-Engineering PDM Extended Objects) cannot be added to this list, and are generated after all other objects.

Common Object Items
The following items are available in various objects located in the Root > Script > Objects category.
Table
The Table category is located in the Root > Script > Objects category, and can contain the following items that define how tables are modeled for your DBMS.
Column
The Column category is located in the Root > Script > Objects category, and can contain the following items that define how columns are modeled for your DBMS.
Index
The Index category is located in the Root > Script > Objects category, and can contain the following items that define how indexes are modeled for your DBMS.
Pkey
The Pkey category is located in the Root > Script > Objects category, and can contain the following items that define how primary keys are modeled for your DBMS.
Key
The Key category is located in the Root > Script > Objects category, and can contain the following items that define how keys are modeled for your DBMS.
Reference
The Reference category is located in the Root > Script > Objects category, and can contain the following items that define how references are modeled for your DBMS.
View
The View category is located in the Root > Script > Objects category, and can contain the following items that define how views are modeled for your DBMS.
Tablespace
The Tablespace category is located in the Root > Script > Objects category, and can contain the following items that define how tablespaces are modeled for your DBMS.
Storage
The Storage category is located in the Root > Script > Objects category, and can contain the following items that define how storages are modeled for your DBMS.
Database
The Database category is located in the Root > Script > Objects category, and can contain the following items that define how databases are modeled for your DBMS.
Domain
The Domain category is located in the Root > Script > Objects category, and can contain the following items that define how domains are modeled for your DBMS.
Abstract Data Type
The Abstract Data Type category is located in the Root > Script > Objects category, and can contain the following items that define how abstract data types are modeled for your DBMS.
Abstract Data Type Attribute
The Abstract Data Types Attribute category is located in the Root > Script > Objects category, and can contain the following items that define how abstract data type attributes are modeled for your DBMS.
User
The User category is located in the Root > Script > Objects category, and can contain the following items that define how users are modeled for your DBMS.
Rule
The Rule category is located in the Root > Script > Objects category, and can contain the following items that define how rules are modeled for your DBMS.
Procedure
The Procedure category is located in the Root > Script > Objects category, and can contain the following items that define how procedures are modeled for your DBMS.
Trigger
The Trigger category is located in the Root > Script > Objects category, and can contain the following items that define how triggers are modeled for your DBMS.
DBMS Trigger
The DBMS Trigger category is located in the Root > Script > Objects category, and can contain the following items that define how DBMS triggers are modeled for your DBMS.
Join Index
The Join Index category is located in the Root > Script > Objects category, and can contain the following items that define how join indexes are modeled for your DBMS.
Qualifier
The Qualifier category is located in the Root > Script > Objects category, and can contain the following items that define how qualifiers are modeled for your DBMS.
Sequence
The Sequence category is located in the Root > Script > Objects category, and can contain the following items that define how sequences are modeled for your DBMS.
Synonym
The Synonym category is located in the Root > Script > Objects category, and can contain the following items that define how synonyms are modeled for your DBMS.
Group
The Group category is located in the Root > Script > Objects category, and can contain the following items that define how groups are modeled for your DBMS.
Role
The Role category is located in the Root > Script > Objects category, and can contain the following items that define how roles are modeled for your DBMS.
DB Package
The DB Package category is located in the Root > Script > Objects category, and can contain the following items that define how database packages are modeled for your DBMS.
DB Package Sub-objects
The following categories are located in the Root > Script > Objects category:
Parameter
The Parameter category is located in the Root > Script > Objects category, and can contain the following items that define how parameters are modeled for your DBMS.
Privilege
The Privilege category is located in the Root > Script > Objects category, and can contain the following items that define how privileges are modeled for your DBMS.
Permission
The Permission category is located in the Root > Script > Objects category, and can contain the following items that define how permissions are modeled for your DBMS.
Default
The Default category is located in the Root > Script > Objects category, and can contain the following items that define how defaults are modeled for your DBMS.
Web Service and Web Operation
The Web Service and Web Operation categories are located in the Root > Script > Objects category, and can contain the following items that define how web services and web operations are modeled for your DBMS.
Web Parameter
The Web Parameter category is located in the Root > Script > Objects category, and can contain the following items that define how web parameters are modeled for your DBMS.
Result Column
The Result Column category are located in the Root > Script > Objects category, and can contain the following items that define how web services and web operations are modeled for your DBMS.
Dimension
The Dimension category is located in the Root > Script > Objects category, and can contain the following items that define how dimensions are modeled for your DBMS.
Extended Object
The Extended Object category is located in the Root > Script > Objects category, and can contain the following items that define how extended objects are modeled for your DBMS.

Parent topic: DBMS Definition Files