description for table from make-table query

[folkie]

Is there a way to create a description in the database window for a table that gets created when running a make-table query? I have several make-table queries that will get run often, in order to get up-to-date information for a report. Now, when the make-table query is run, the description in the database window is blank. Since I have descriptions for most of my objects in the database window, I'd like to have a description (which would be the same every time the make-table query is run) for my tables created from a make-table query.

 

[Fornatian]

Instead of using a make table query why not use delete and append querys to retain the table structure and descriptions.

 

[folkie]

Ian,

I never thought about delete and append queries, but that sounds like 2 steps for each make-table query that I have. It took me awhile, a few months ago, to switch from all select queries to select and make-table queries (when I was getting "query is too complex" messages). I'd rather not deal with switching things again if I don't have to.

After posting my question, I did find some code that's supposed to put a description out there. I haven't tried it yet, but hopefully I'll be able to adapt it to what I'm doing.

 

[Fornatian]

Creating and deleting table can over all be less efficient because they can cause database bloat form creation and deletion of database objects.With the suggested methodyou retain the table and only delete/append information.