DROP_FKS_NOT_IN_SOURCE

The DROP_FKS_NOT_IN_SOURCE CM batch parameter specifies whether the compare process is to drop from the target table any foreign keys that are not specified in the corresponding source table.

Values:

YES or Y

If a table on the target has foreign keys and the table also exists on the source, all foreign keys that are not also on the source will be dropped from the target.

NO or N

The drop behavior is determined by the SUPPRESS_DROP_OF_OBJECTS parameter.

Default:

NO