Don't know if this has been mentioned, but dbcgen.prg will do just that - be careful, though, running it will create BLANK tables hosing existing data.

The code in the prg however will give you a pretty good idea of how it works.

but better yet, use Stonefield - it will generate tables on startup from metadata if the table doesn't exist and fix its structure to match dbc changes if you've made them to for existing tables. A must-use in my opinion


>Thanks, everyone:
>
>Here is what I was hoping to do:
>
>I want to add the CREATE TABLE command to my code so that the tables get created at run time without requiring that one exists yet. I want to start doing that for all my temp tables that are used for imports, etc.
>
>I can certainly manually write the CREATE TABLE commands for each of these tables, but what a pain, especially for some tables that have a ton of fields (one has 240 fields). Most of these tables already exsist, so I was hoping that someone had written a program that could examine the table structure and build the 'CREATE TABLE' command for me.
>
>I can write it myself, I have written a program that will compare one free DBF against another and builds a program to correct the table that is missing fields using ALTER TABLE - I was just hoping someone out there in the great world of Universal Thread has already done this.
>
>Thanks for all your advice,
>
>Michael