Deleting Rows from Extension Tables

You cannot delete a row from one-to-one extension tables (*_X type) without removing its parent row. For example, to remove a row from S_CONTACT_X, you must remove the parent row from S_CONTACT.

If you have to delete data in an extension column, update it with NULL by setting NET CHANGE = FALSE in the configuration file, and if necessary, use ONLY BASE COLUMNS.