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.
The summary section at the top of the page displays the selected database name, the selected table, the schema name, the number of rows in the selected table, and the number of columns in the selected table.
The detail section displays the following information:
Name - The property name, the second key part of the property.
Type - The property type, such as Text, Identifier, DateTime, and so on.
Max Length - Indicates the maximum length, in characters, not bytes, of the property, from the Max Length field on the Advanced tab of the Property form.
Class - The Applies To key part of the property.
Class key? - Not used.
Column Visibility - The value of the Column Inclusion field on the Advanced tab of the Property form, if the value is required or recommended. These values are advisory only.
Name - The name of the database column. It can vary from the property name in case or format.
Datatype - The column's database type.
Size - The size of the column, in characters. The default width is 64 characters, or the maximum length of the property if defined for the property. If you change these values, update the Max Length values on the Property form if they have been defined.
Note: If a selected property has non-blank values in some rows in the Storage Stream (BLOB) column, copy the existing values into the new column by using the Column Populator utility.
Open topic with navigation