Build Options in Application Designer

i) Table Creation Options:

Recreate table if it already exists: Select to drop and re-create a table if it already exists. If data already exists in the table, it is also dropped.

Skip table if it already exists: Select to create only those tables that are newly defined.

ii) View Creation Options

Recreate view if it already exists: Because views are just logical views of data, it is safe to select this option; you don't run the risk of losing physical data.

Skip view if it already exists: If you're concerned only with creating views that do not already exist in the database, select this option.

iii) Index Creation Options

Recreate index if it already exists: Select to re-create the index for your tables, even if you already have one in place. It re-creates the index no matter what the situation.

Recreate index only if modified: Select to re-create the index only if the data is being modified in the indexes.

Drop Column Options

These options are referenced whenever a field is deleted from a PeopleTools record definition where data exists in the database for that column.

Drop column if data Present; Select to drop the column and data and write a warning to the build log.

Skip record if data Present: Skips the record, and write an error message to the log. Processing continues with the next record.

Alter in Place:

Selected by default. For database platforms in which Alter in Place is not supported, alter is automatically done by Alter by Table Rename (even if that option is not selected).

Oracle DB doesn’t support Change Column (data type, size, precision, scale, and null/not null property change)

Alter by Table Rename

Select to create a temporary table (with changes made to the original table or its fields); the data from the original table is imported into the temporary table. The original table is then dropped and the temporary table is renamed to the original table.

If a table is renamed from the old name to a new name, the indexes that were created on the old table are moved to the new table, but the index names remain in the old table's name. With Alter by Table Rename selected, the indexes of the old table are dropped before being renamed to the new table name and the indexes are re-created after the table is renamed to the new name. This way, the index is created in the new table's name.