Hi all,

In one instance i had two diffrent databases , i want the distinct tables from two databases .

Example: I had one instance named db2 in that i had two databases sample1 and sample2 , so there are 10 tables in sample1 and 15 tables in sample2 . Now i want distinct tables from both the batabases. So i want to write a script for that. Please reply as soon as possible.


Thanks in advance.

Use DB2 federation and access the catalog views in one database from the other database via nicknames. Then you can use regular SQL to find the differences.