Comparing two tables for missing columns
Hello,
I am more accustomed to Oracle.... am still thinking in terms of Oracle...
Please help me with this issue.
I am trying to compare two tables A and B...
I want only the column names of the missing column on the other database...
in other words I want
A intersection B for column names &
B intersection A for column names...
I am not interested in the data that is present in those columns.
Then I need to add / alter the tables A and B to make them similar. Eg:
A B
-------------------------------
Name Name
Class Section
County County
State District
Country Country
I need
A intersection B = Section, District
B intersection A = Class, State
and then make them
A B
-------------------------------
Name Name
Class Class
Section Section
County County
District District
State State
Country Country
Please help.
Thanks
Shree
|