>Is there or better, what is the command that tell you how many tables are open. I want to close all of the open tables in a program and don't always know all the names of the open tables(depending on the situation it might be one or more days worth of data).

I think you are looking for AUSED(), but this will only apply to tables within the current datasession. If others sessions are active, you will have to poll them also.