Modifying a schema by using the Modify Schema wizard
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
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
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.
pr_othertable, 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.