Electra
05-08-2008, 09:57 AM
Hi,
I have been given a large database to sort out. I know roughly what I'm doing, but I am hardly experienced. Basically, it has long lists of tables and queries. I am told that perhaps fields appear multiple times in separate tables, but there are so many tables it would take hours to sort through by hand! What I want to know is- is there any easy way that I can tell if certain named fields are included in multiple tables? Any automatic process by which I can check if fields appear more than once?
Thanks Guys,
Electra
x
I have been given a large database to sort out. I know roughly what I'm doing, but I am hardly experienced. Basically, it has long lists of tables and queries. I am told that perhaps fields appear multiple times in separate tables, but there are so many tables it would take hours to sort through by hand! What I want to know is- is there any easy way that I can tell if certain named fields are included in multiple tables? Any automatic process by which I can check if fields appear more than once?
Thanks Guys,
Electra
x