Re: temp tables

[Ron Rose]

One method: PROJECT DROP Table RENAME   ----- Original Message ----- From: mjs To: [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 12:22 PM Subject: temp tables If I have a temporary table, what is the best way to get rid of it?  DISC follwed by CONN dbname works, but it's slow in a multi user environment.  Would it be better to use DROP TABLE tablename and then recreate it?  Or just "overwrite" by running the command file that created the temporary table and then delete any rows in the table in case the overwrite fails cuz the table already existed? Or some other method??   TIA!   Mike Sinclair