ADD TRANDATA <table name> will add the supplemental logging to all columns of table if the table does not have either primary key or a unique key. Once we applied the ADD TRANDATA how do we revert it and apply the supplemental logging to a specific column.
If I issue the below command, will it remove the existing supplemental logging with all column and to be specific to the list of column list?
ADD TRANDATA <table name>, COLS (list of column names), NOKEY