Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
share|improve this question

migrated from Dec 3 '12 at 2:27

This question came from our site for system and network administrators.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.