can anybody please explain to me the use of this function which is not detailed in the help_file?
I have been proposed this as part of a code to clean up all existing tables (but for specific ones), but I guess it can also be used in combination with the TRACE command to see which tables exist at a given point, e.g. within a subroutine, each time it is called.
From the help_file I know that it takes the table_number as a parameter - but what is the table_number?
the context was a subroutine and for some reason some fragmented tables were being created in the individual iterations, but I didn't know for sure where and why - and I cannot write a DROP statement for a fragment anyway beecause of the "-" ...
Of course, whenever you know the names of interim tables, dropping them right away with this statement is the more elegant solution.
Also, I am having trouble with the TRACE: I can set a variable to TableName(0) and then write a TRACE statement with the value of that - but somehow writing TRACE TableName(0) or something like that won't work.