If I understand your request, you want to build a table of column names, types, lengths, etc. for a bunch of free tables in order to rebuild them.
Ed was correct, your best bet is to use AFIELDS() to get an array of field information. You can then store the array into a structures' table along with each table name. When recreating, load an array from the table and then use CREATE TABLE xxx FROM ARRAY yyy as Ed indicated. It gets tricky if you need to save table information for more than one version of VFP -- they array structure has changed over the versions. No problem if you just want to operate in one version. For Instance, VFP 9 AFIELDS() creates an array of 18 elements. The first 4 are important, the rest can be set to their default values... Good luck; Chet Jeff wrote: >I need to be able to recreate free tables using information stored in >tables. I know how to create tables using SQL statements but how >would I pull the field [column - hate that about VFP!] information >[column name, type, character/column length,... - all stored for >reporting] to create a new table? > >jeff fisher, MCP >www.turbofish.com > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.