>Hi All!
>
>Is there a function in VFP to determine what tables are contained in a specified database? And would that function also include returning specific and needed information regarding that table in relation to the database? Im planning to recreate a database from an existing database, add specified tables to it, and append all necessary details to it. Ive come across a similar thread the other day here but i could't recall it anymore.

release laTables
               lnTables=adbobjects(laTables, "TABLE")  && Create list of all tables in Database
               =asort(laTables)

Also check InDBC function.
Anyway, it's not a simple task. We rolled our own DataDict application, but it's tough. I haven't used Stonefield, but here in UT I saw lots of references to this product. Check it out, may be it will fit your need exactly and will save you from lots of efforts...