Skip to main content

Modifying a schema by using the Modify Schema wizard

Suggest edit Updated on May 11, 2022

You can view and modify the PegaRULES database schema by using the Modify Schema Wizard. You can determine which concrete classes are mapped to each database table, which properties in each class are exposed as distinct columns, and which Single Value properties in each class are not exposed but are contained in the Storage Stream (BLOB) column.

You can also use this wizard to copy a Single Value property from the Storage Stream and expose it as a column or to generate a SQL statement (as a text file) to change the database schema later.

Note: You cannot use this tool to expose a transient property, because a transient property has no values in the database. You also cannot select the pr_other table, because no Data-Admin-DB-Table instance is linked to it. Use database utilities to move the rows to a more appropriate table, and then create an associated Data-Admin-DB-Table instance. You can then use this wizard to expose the columns.
  • Exposing properties using the Modify Schema wizard

    You can modify the PegaRULES database schema using the Modify Schema wizard. To make changes to the database schema, your connection to the PegaRULES database must have the ALTER TABLE and CREATE TABLE capabilities.

  • Exposing embedded properties

    You can expose only top-level Single Value properties as columns. However, you can expose embedded properties using one of the following methods.

  • Previous topic Removing the optimized status from a property
  • Next topic Exposing properties using the Modify Schema wizard
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us