>Has anyone written a 'Create Table command' generation program that will create that command by evaluating a real table?
>
>If so, do you mind sharing? We have several large tables (many fields) that we want to start creating programmatically, and I don't want to manually build the entire 'CREATE TABLE' command.
>
>Thanks, Michael

lol

If, on the other hand, you really wanted the actual text of the CREATE TABLE so you can embed it in a program (i.e., you aren't going to have the original table to look at) then you will need something else entirely. You could provide system copies of important tables that are simply used as the template for making the live copies (using something like that function) but I can see how you might prefer the hard coded method.

It wouldn't take much more to return a text string from a function based on the AFIELDS() array data of the original table during design time - then cut and paste the text into your program so you don't have to hand code it - and with intellisense you could even make it automatic if you wanted to (part of the IDE). It's all in AFIELDS() but the indexes. A simple CASE structure in the function to evaluate each array 'field' and concatenate the string till you have the whole table. There are only so many field types so it would be a small function too.