Compare 2 tables

[Son Nguyen]

Hi,

How do you compare 2 tables? (see if they're identical or not - if not, which field/row)

Thanks

[freakysid]

I can't think of any short-cut way of doing that. I mean its completely illogical that a database would have two tables that are identical

I can only think that you would need to put the contents of the tables into arrays and just step through the arrays comparing each elemet

[James]

Or you could find a text editor/program that does comparisons (eg Beyond Compare is an excellent one, not sure of URL though). Then dump the two tables to seperate text files and compare those?