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