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 Defining Generation and Reverse-Engineering of New Metaclasses) 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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
The following categories are located in the Root > Script > Objects category:
Parameter Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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 Category (DBMS)
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