If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Comparing two tables for missing columns
Unfortunately Access doesn't have any views like DBA_TAB_COLS where this
would be easy. You'll need to do some coding. Here's a place that might help: http://www.freevbcode.com/ShowCode.asp?ID=184 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Princy" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|