How to select certain columns to NOT compare?

DrDataDrData Posts: 7 Bronze 1
in SQL Data Compare
I have many tables that have an 'entry date' column that auto-fills based on when the record actually inserts into the table. When I am comparing tables, I only want to see records where any OTHER fields are different. How can I exclude certain columns from comparison?
· Share on Twitter

Answers

  • DrDataDrData Posts: 7 Bronze 1
    Upon taking another look, I found that on the "Tables & Views" screen, all the way to the right, you must click "x of x columns" That will then open a window where you can uncheck specific columns. So obvious that I missed it! :dizzy:
    · Share on Twitter
Sign In or Register to comment.