We have a scenario where we have added KEYs on tables in our channels (as keys are not defined in source db), but whenever an alter statement is run in source like "alter table add/drop partition" then the keys defined on the tables are auto-removed. full details in support ticket #139202

Suggested by HVR support to raise a feature request.