All keywords are case-insensitive.
...
Unprepares a schema/table for replication and declares that this object should no longer be replicated. This will only take affect after a restart of the mine process
If OFFLINE is used, apply/mine will pick the change on the next start. Use OFFLINE if the apply and mine are not running, as some network configurations may cause long timeouts while PREPARE tries to connect to the apply/mine.
EXCLUDE COLUMN
Set a column to be excluded in mining. Use this if you don't want to replicate a specific column(s) in a table. Use the % character as a wildcard. Underscore (_) is not treated as a special character.
Note that PREPARE automatically includes all columns and EXCLUDE thus must follow the prepare. The table must already be PREPARED for the column to be excluded.
...
Set filtering rules for an already prepared table/schema. The usual way how to configure filtering is using Setup wizard (which in turn uses this very command).
If OFFLINE is used, apply/mine will pick the change on the next start. Use OFFLINE if the apply and mine are not running, as some network configurations may cause long timeouts while PREPARE tries to connect to the apply/mine.
CDCAUDIT
...
The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.
SHOW_CONFLICT_HANDLERS
Shows current setting of conflict handlers for given table (schema.name refers to table at mine).
...