Barry

>Is there a way to get a list of Information tables that are available instead of relying on those documented in the manual?

Bribing or torturing Tim are the only possibilities I can think of

Roy

Barry,

<< Is there a way to get a list of Information tables that are available
instead of relying on those documented in the manual? >>

I'm not sure if you're being serious here, but the information tables in the
manual are the only information tables in EDB.

<< As we all know, there is information.tables that shows the user tables
used in the database, but is there an information.informationtables that
shows the internal tables (information tables) that are available? >>

Yikes, EDB has to stop at some point.

Tim Young
Elevate Software
www.elevatesoft.com

Barry,

<< but no:
information.temporaryindexes

Is there a way I can determine if a temporary table has an index made from
certain column names? For regular tables I can easily do this with
information.indexes, but for temporary tables I'm at a loss. >>

I'll see what I can do.  Originally, the Temporary* versions of the various
information tables were kept to a minimum to prevent things from getting a
little confusing.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com