list of all tables and items in a database
Posted on 2004-11-07
I just started working in a new company. They have tons of databases but no structure or standard. I would like to build a tool that will go threw each database and get the list of tables, the items in it and the type. After that I could see all the discreptencies amd fix them. So my question would be if there is functions in vba that will alow me to get all the information on the structure for a given database.
Thank you for any input on the subject.