If you modify a relational target definition, use the Designer to drop and re-create the corresponding target table.
When you drop a target table, the Designer deletes the table from the database. If you want to keep the target data, back it up before you drop the table.
To re-create the target table:
In the Target Designer, modify the relational target definition and select it.
Click Targets > Generate/Execute SQL.
In the dialog box, connect to the appropriate target database. Select the DROP options checked for the table and any indexes on the table.
Click Generate and Execute.
The Designer drops and re-creates the table, including any indexes assigned to it.
ASK INFAPreview
