Search code examples
databasedatabase-schemafoxprovisual-foxpro

Is there any way to retrieve a schema from a directory of fox pro 9 free tables?


While looking for a way to discover the relationships between fields in Sage ABRA Suite I came an answer that sounded like if you have a free table directory with Visual Fox Pro, you're going to be stuck guessing at what the schema really is:

"Is this just a set of VFP free tables or is there a VFP database, as well? If there's a database, you'll have files with DBC, DCT and DCX extensions."

Is this really the case? I checked my ABRA installation's Data directory (a free table directory according it's ODBC connection) for files with *.DBC, *.DCT and *.DCX extensions and I didn't find any of them.


Solution

  • Yes, in a situation where it is just free tables you will only establish the schema in terms of inter-table relationships and the general structure of how the data hangs together if this has been published by Sage, because there is no metadata anywhere defining this information.