SQL how to check that two tables has exactly the same data?

Question

I have two tables TableA and TableB which have the same format of columns, which means both tables have the columns

A B C D E F 

where A and B are the primary keys.

How do I write an SQL query to check if TableA and TableB (that have the same primary keys) contain exactly the same values in every column?

It means that these two tables have exactly the same data.

Answer 1

You should be able to "MINUS" or "EXCEPT" depending on the flavor of SQL used by your DBMS.

select * from tableA
minus
select * from tableB

If the query returns no rows then the data is exactly the same.