Table of Contents

Modifying a schema by using the Modify Schema wizard


Only available versions of this content are shown in the dropdown

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.

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.

Have a question? Get answers now.

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