Types of Changes

The additive schema files generated by the Upgrade Wizard make the following types of schema changes to support the new release. These changes do not adversely affect data integrity or database normalization:

• Creating new tables.

• Adding columns to an existing table. The column must either be specified as null, or if the column is not null, it must have a specified default value.

• Creating nonunique indexes on new tables.

• Creating or altering a unique index on an existing table provided the CLUSTER attribute is not specified for the index.

• Increasing column sizes for numeric or varchar columns. The column must not be the basis for a drop-down list. Also, the resultant cumulative row size must not be larger than the data page size.

• Changing a not-null column to null.

• Changing a data type from char to varchar.