View Full Version : Automatic method of checking for table/field redundancies


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

Fifty2One
05-08-2008, 01:04 PM
You can right click and check the object dependencies.