There is a single file here in the files section called gentable.zip that contains two programs. Gentable, and genview. They look at view and table definitions respectively, and generate code that will recreate the table or view. You can run this code on the new database.
>I'm hoping I'm missing the boat on a much easier way to accomplish this task, and hope someone here can point me to an easier way to accomplish the following.
>
>Currently, if I need to "copy" the structure of a view or table from my test dbc to my live dbc, I have to open the development view, list view to a text file, open the text file (for reference), then open the live dbc, and using the information in the text file I generated, manually re-create that view or table in the corresponding designer. I know I could use the information in the text file to build a create view or create table statement, but that takes nearly as long to do as opening the designers to do the job.
>
>I know with a table, I could simply do a copy struc to a free table, but if I do this, the table is constrained to the limitations of field name sizes, file name length, etc.... that dbc's do not have.
>
>Is there an easier, yet non-destructive way to accomplish this?
>
>Any suggestions would be greatly appreciated.
>
>thanks,
>
>JE
Erik Moore
Clientelligence