Select all colums as comparison key

Ranvir

Hi all,

I'm trying to do a comparison between two databases. Unfortunately the developer has not put any primary or unique keys on any of the tables so I'm having to manually add comparison keys to each table.

I want to select every column for each table as my comparison key.

However I have to click on each column to add it as a comparison key, this is taking me a long time.

Is there any quicker way to select all columns?

Thanks

Ranvir

It's ok, I found out how to do this, in each table you can select all columns by doing a Select + A, which will select all columns and then click on one of the columns. This will then place a tick next to all columns.