Mike, I like DROP TABLE tablename. DISC has the side effect of dropping all cursors you might have open at the moment. The overwrite idea might work, but it's not as obvious what the expected result is when you come back to modify the program a year down the road.
Bill On Tue, 25 Jun 2002 15:22:52 -0400, mjs wrote: >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?? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
