>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...
If it's not broken, fix it until it is.
My Blog