问题:

I have some dbf files of foxpro database. However, I have no idea about what are relationship between tables regarding foreign key, what tables are inter related and so on. Is there any tool which can help me to learn relationships easily. I mean which can draw relationship instead of me figuring out by hit and try.? I want to export this database to Microsoft SQL Server. So I want to learn whole database schema to learn tables logic. Thanks

回答1:

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. If you have those, open the database and take a look:

OPEN DATABASE whatever
MODIFY DATABASE

If there are relationships defined between the tables, you'll see them there.

VFP ships with a program called GENDBC that will generate code to recreate a database. Since it's all SQL code, that might help you to see what's in there, as well.