Hi everybody,

I need to understand, where Fox tries to create temp files during INDEX ON and ALTER TABLE commands on huge tables. I was thinking, it uses current place for temp files, but it seems, like it uses current location of databases instead.

I'd like to check for available space before running ALTER TABLE / INDEX ON command, and I need to know, how many space I need and where.

My second question is: can we re-direct temp files to the specific location for the specific application (this application is run under another main application). If yes, how?

Thanks a lot in advance.