I am not sure if this can be don, but I have a few tables that I would like to compare. I want to see what Field Name match other tables.
Example if I have Table A that has First Name, Last Name, Address, ZIp, etc and Table B has First, Name, Last Name, Middle Name, Address, Zip etc.
I want to know that Table A is different because it doesn't have the field Middle Name.
I know we can match on records, but I actually want to match on field Names.
Can this be done?
Thanks in advance.