What are the challenges you face when working across database platforms? Take the survey
Options

How to select certain columns to NOT 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?

Answers

  • Options
    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:
Sign In or Register to comment.