I´m not sure if I did understand you correctly, but if you want to get the structure of all your tables in the database do

select * from sysobjects where type='U'

and get the structure by using the SQLCOLUMNS command of VFP.

...gerhard...